* 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