# 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](https://www.ask-codey.com/glossary?category=database&level=3)

Updated: November 9, 2026

Source: https://www.ask-codey.com/glossary/second-normal-form-2nf
