Glossary term
What is normalisation? Meaning for developers
Organising tables so each fact is stored once, which avoids update mistakes.
Learn it properly · SQL & PostgreSQLLesson 4: Designing a Schema: Keys, Normalisation and ConstraintsIdentity versus UUID keys, normal forms with a flat-to-normalised redesign, ON DELETE, enums, money, timestamptz and soft deletes.