Neocortex 🧠

Search

Search IconIcon to open search

2nd Normal Form (2NF)

Last updated Dec 14, 2021 Edit Source

Any 2NF schema must also be 1NF, however, there are some extra requirements for a Relational Model to be 2NF. It must not contain any Partial Dependencys.

In order to apply Normalizing a Relational Model to a relation that has a Partial Dependency, we apply a Projection $\pi$ over the relation with two sets of attributes, one of which being the attributes that define the dependency and the attributes that depend on the dependency, and the other one being the original relation with the dependants of the dependency removed.


Interactive Graph