Advancing Database Normalization

Learn the third and other database normalization forms.

We'll cover the following

Third normal form (3NF)

The third noraml form (3NF) is the third step in the normalization process. To achieve this state, we must ensure that the 2NF and the 1NF must be satisfied.
The condition for 3NF is as follows:

  • The 2NF must be satisfied.

The goal of the 3NF is to:

  • Eliminate any transitive functional dependencies.

Eliminating transitive functional dependencies

A table that explains the 3NF is as follows:

Get hands-on with 1400+ tech skills courses.