Today’s topic is normalization. If your database were a piece of dirty laundry, normalization would be a kind of wash-rinse-dry process. But in this case, shrinking wouldn’t be a problem.
By Rafael Victória-Pereira
Normalization, explained in the first TechTip of this series, is more than just a theoretical concept. It’s time to put it to work in your database.
Normalizing the Database
In this stage of the modernization process, it would be a good idea to take some time and revisit the database design, review the notes you took earlier, and have another look at the Entity Relationship Diagram you drafted. Then, follow the normalization process and update your logical database model’s tables to conform with the second normal form, at least. The following steps are involved in this stage: