In this lesson you will learn how to break up a raw collection of data into more logical units, or tables, to reduce the occurrence of redundant data in the database. This process of reducing data redundancy is referred to as normalization. We will also discuss the advantages and disadvantages of a normalized database versus a normalized database that has been denormalized, as well as data integrity and performance issues that pertain to normalization.
By the end of this lesson, you should understand and be able to apply the following concepts:
• Benefits of normalization
• Guidelines of normalization
• The three normal forms
Normalization is the process ...