Second Normal Form

relational-algebra

Definition

Second Normal Form

A schema $\mathcal{R}$ with functional dependencies $F$ is in second normal form if all non-prime attribute $A\in \mathcal{R}$ are fully functional dependent on every key candidate of the delation.

In other words, a schema is in second normal form if it does not consist of any partial dependencies. No non-key-candidate attribute should determine any other attribute in the relation.