Once a relational database system has been designed, it should be normalized. Database normalization helps to organize data and eliminate redundancy in a database. This lesson explains how to normalize a database, and explains why you may want to denormalize a database.
After this lesson you will be able to:
- Explain the steps of entity-relationship modeling.
- List the normalization rules.
- Explain why you would want to denormalize a database.
- Describe three strategies of denormalizing databases.
Estimated lesson time 25 minutes