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