Module 5: Database Design and Normalization

Entity-Relationship (ER) Model

Explore the process of designing a database using the ER model. Learn how to create entity-relationship diagrams that accurately represent database structures.


Understand the theory and practice of normalization. Learn about the different normal forms (1NF, 2NF, 3NF, BCNF) and how to apply them to eliminate redundancy and improve data integrity.