1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
* EER and relational (notations, translation, ER -> EER)
* Languages (DML - DBA or User, DDL - , VDL, SDL)
* DBMS system components
User queries and DDL queries paths
* Conceptual Data Modeling (Focus on min-max) (ER and Enhanced ER model)
Partial participation, categorization on unions,
convert to integrity constraints
non-null is an entity integrity constraint
* Relational model concepts
** Keys
(Super key, candidate key, primary key, foreign key)
studentno is a key, {studentno, birthdate} is a superkey
sometimes there is more than one key
* Data Definition Language (DDL)
** Creating table, adding constraints, table attrributes
** DBA uses
** Attributes, primary keys, foreign keys
** Drop table, Alter table
** Constraints: null/not null, unique, CHECK
|
