3rd Normal Form (3NF)

Last updated Dec 14, 2021 Edit Source

Any 3NF schema must also be in 2nd Normal Form (2NF). The only extra requirement is that there is no Transitive Dependency between the Primary Key of the relation and another attribute.

In order to convert a Relational Model in 2NF to 3NF, we apply Projection $\pi$ on the functional dependency that is causing the dependency.