Database Design Concepts

A well-designed database stores every fact once, keeps data correct, and answers questions quickly — properties that come from design, not luck.

Poorly designed tables develop predictable diseases: redundancy and the three anomalies. Recognising them motivates normalisation.

Normalisation splits a bloated table into related tables so each fact lives once — eliminating the anomalies at their source.