IT lexicon Database Normalization

Normalization

Database På svenska → Updated: 2026-05-23

Design principle for relational databases — no redundant data, everything in its place.

Normal forms 1NF-5NF; 3NF is usually enough. Trade-off: 3NF = clean but lots of JOINs. Denormalisation = duplicate data for faster reads (common in modern apps and OLAP). No longer dogma — context decides.

← Back to the lexicon