Database Normalization - Third Normal Form (3NF)

The third normal form checks for transitive dependencies.

  • Eliminate fields that do not depend on the key

Values that are not part of the record’s key do not belong in the table .

In general if the contents of a group of fields apply to more than a single record, put those fields in a separate table.