first normal form
The rule that every column holds a single value and a table has no repeating groups of columns or lists packed into one cell.
In more detail
A column holding 'mouse, cable' or columns named product1, product2 break it. The fix is a separate table with one row per item.
Related terms
- normalisation — Designing tables so each fact is stored in exactly one place, by splitting repeated data into related tables.
- 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.
Taught in
- Normalisation To Third Normal Form — PostgreSQL, Indexing & Relational Data Modeling