Database Normalization

Database Normalization By: K. Turner Normalization in its most literal sense means: To make (a text or language) regular and consistent, especially with respect to spelling or style. 1 Normalization with regard to database technology takes on a slightly different meaning, but the concepts of consistency and organization remain the same. As a database grows, it grows not only in size, but also complexity. This inevitability provides a need to maintain order and organization. The best …

…keys (FK) are then placed in the appropriate tables to provide relationships and to maintain referential integrity between the newly created tables. Bibliography 1 Excerpted from the American Heritage Dictionary of the English Language, Third Edition Copyright © 1992 by Houghton Mifflin Company 2 Database Systems 5th Edition Rob and Coronel 3 Systems Analysis and Design in a Changing World 2nd Edition Satzinger, Jackson, and Burd 4 http://www.devshed.com/ 5 http://www.utexas.edu/its/windows/database/datamodeling/index.html