DATABASE DESIGN (2 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to: LO1 – define database concept and the stages of database design based on Database System Development Life Cycle; LO2 – Describe the relational model and relational algebra; LO3 – build Entity Relationship Modelling, normalization and SQL; LO4 – analyze database design phases include conceptual, logical, and physical.

Topics:

1. Introduction to Databases;
2. Database System Development Lifecycle;
3. Entity Relationship Modelling;
4. Enhanced Entity Relationship Modelling;
5. Normalization;
6. Advanced Normalization;
7. The Relational Model;
8. Relational Algebra;
9. Data Definition Language;
10. Data Manipulation Language;
11. Methodology – Conceptual Database Design;
12. Methodology – Logical Database Design;
13. Methodology – Physical Database Design for Relational Databases;
14. Normalization;
15. Entity Relationship Modelling;
16. Advanced Normalization;
17. Conceptual Database Design;
18. Logical Database Design;
19. Physical Database Design for Relational Databases;
20. Quiz.