Microsoft Windows Architecture for Developers Training Kit
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.