DATABASE DESIGN (2/1 CREDITS)

Learning Outcomes:

On successful completion of this course, students will be able to: define  database concept and the stages of database design based on Database System Development Life Cycle; Describe  the relational model and relational algebra; build  Entity Relationship Modelling, normalization and SQL; 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.