Advancing Database Normalization

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 1200+ tech skills courses.