DATABASE DESIGN (2 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to:

1. Define database concept and the stages of database design based on Database System Development Life Cycle
2. Describe the relational model and relational algebra
3. Build Entity Relationship Modelling, normalization and SQL
4. 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 Query Processing
7. Methodology – Conceptual Database Design
8. Methodology – Conceptual Database Design
9. Methodology – Logical Database Design
10. Methodology – Logical Database Design
11. Methodology – Physical Database Design for Relational Databases
12. Methodology – Physical Database Design for Relational Databases
13. Review