normalisation

Designing tables so each fact is stored in exactly one place, by splitting repeated data into related tables.

In more detail

A normalised design avoids copies that can disagree, such as a customer's city repeated on every order line. The steps are called normal forms: first, second and third. Joins then rebuild the combined view whenever you need it.

Related terms

Taught in

References