| Learning Outcomes | Introduction to DBMS 1.1 The evolution of database technology 1.2 Characteristics of the database approach 1.3 Components of a DBMS 1.4 Advantages of using the DBMS approach |
| Database architecture and modeling 2.1 Three-Schema architecture 2.1 Categories of data models | |
| Database design process 3.1 Database system development life cycle 3.2 Database design stages | |
| Relational Data model 4.1 Relational Model terminology 4.2 Keys 4.3 Constraints 4.4 Relational algebra | |
| Entity-Relationship model 5.1 ER concept & terminology 5.2 Entities, Relationship & Attributes 5.3 ER Diagrams 5.4 Mapping conceptual model into a relational schema 5.5 Introduction to EER modeling | |
| Data Normalization process and the normal forms 6.1 Introduction to data normalization 6.2 1st Normal Form ( 1st NF ) 6.3 2nd Normal Form (2nd NF) 6.4 3rd Normal Form ( 3rd NF ) 6.5 Boyce-Codd Normal Form | |
| Data manipulation using SQL 7.1 Introduction to SQL 3.2. DDL 3.3. DML | |
| Physical database design 8.1 File structures 8.2 Storage devices |
Database Systems 1_Module