O'Reilly logo

Sams Teach Yourself SQL in One Hour a Day, Fifth Edition by Arie D. Jones, Ron Plew, Ryan Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required