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