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
- normalisation — Designing tables so each fact is stored in exactly one place, by splitting repeated data into related tables.
- composite key — A key made of two or more columns together, such as order and product on an order line.
- third normal form — The rule that every non-key column depends directly on the key, not on another non-key column.
Taught in
- Normalisation To Third Normal Form — PostgreSQL, Indexing & Relational Data Modeling