Second Normal Form (2NF)
noun
say it: “SEK-und NOR-mul form” /ˈsɛkənd ˈnɔːrməl fɔːrm/
First normal form, plus every non-key column depends on the whole primary key, not just part of it.
What is Second Normal Form (2NF) in a relational database?
Second Normal Form (2NF) — First normal form with no non-key attribute dependent on only part of a candidate key.
In a sentence
- “Moving ProductName out of Order Details put it in second normal form.”
Level: Journeyman · More Database terms at this level
Updated