Normalization
Normalization is a set of standard rules that tests the soundness of database design. It can help prevent the problems described in the first part of this chapter. By applying these standard rules, you can pinpoint design flaws that might jeopardize data integrity and complicate data maintenance.
How to Normalize a Database
There are three standard normalization rules. After a design successfully passes a rule, it is said to be in # normal form (where the # represents 1st, 2nd, or 3rd). Rules are cumulative. For example, for a design to be in 3rd normal form, it must satisfy the requirements of the 3rd normal form as well as the requirements for 2nd and 1st normal forms.
Technically speaking, there are other types of normalization ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
