LESSON 8Database Normalization
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:
• Normalization
• Benefits of normalization
• Denormalization
• Guidelines of normalization
• The three normal forms
Normalizing a Database
Normalization is the process ...
Get Sams Teach Yourself SQL in One Hour a Day, Fifth 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.
