Third Normal Form (3NF)

noun

say it: “THURD NOR-mul form” /θɜːrd ˈnɔːrməl fɔːrm/

Second normal form, plus no non-key column depends on another non-key column.

What is Third Normal Form (3NF) in a relational database?

Third Normal Form (3NF) — Second normal form with non-key attributes depending on keys rather than other non-key attributes.

In a sentence

  • “Moving the city's state out to its own table put Customers in third normal form.”

Level: Journeyman · More Database terms at this level

Updated