Database normalization. Normalization involves refactoring a table into smaller (and less redundant) tables but without losing information; defining foreign keys in the old table referencing the primary keys of the new ones.
The objective is to isolate data so that additions, deletions, and modifications of an attribute can be made in just one table and then propagated through the rest of the database using the defined foreign keys. Edgar F. Description of the database normalization basics. This article explains database normalization terminology for beginners.
A basic understanding of this terminology is helpful when discussing the design of a relational database. NOTE: Microsoft also offers a WebCast that discusses the basics of database normalization. Database Normalization Process - Database Recovery Downloads. Relational Database Normalization Process Illogically or inconsistently stored data can cause a number of problems.
In a relational database, a logical and efficient design is just as critical. A poorly designed database may provide erroneous information, may be difficult to use, or may even fail to work properly.