third normal form

The rule that every non-key column depends directly on the key, not on another non-key column.

In more detail

If a product row stored both category_id and category_name, the name would depend on the category, not the product, so it moves to a categories table. Ask what identifies the row, then what each column really depends on.

Related terms

Taught in

References