Hour 4. The Normalization Process

In this hour, you learn the process of taking a raw database and breaking it into logical units called tables. This process is referred to as normalization.

The advantages and disadvantages of both normalization and denormalization of a database are discussed, as well as data integrity versus performance issues that pertain to normalization.

The highlights of this hour include

• What normalization is

• Benefits of normalization

• Advantages of denormalization

• Normalization techniques

• Guidelines of normalization

• The three normal forms

• Database design