second normal form

The rule that, in a table with a composite key, every other column depends on the whole key and not on just part of it.

In more detail

In order_items keyed by order and product, a product name depends only on the product, so it belongs in products. Tables with a single-column key are automatically in second normal form once in first.

Related terms

Taught in

References