SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond
by Tom Carpenter
Normalization Defined
Normalization is the process used to ensure that a database is properly designed according to relational database principles. The term is best understood by considering what you are attempting to avoid as a database designer or administrator. Common database problems can be all but eradicated through the process of normalization. These problems that present themselves in poorly designed relational databases, such as duplicating data, creating improper data relationships, and constraining data entry, must either be addressed during the design process or through reparations after the database is in production. Needless to say, it is much easier to deal with the problems before the database is actually implemented. You can ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access