Normalisation
Database normalisation explained with one messy table refactored step by step: the update, insert and delete anomalies it causes, first, second and third normal form, BCNF in brief, and when deliberate denormalisation is the right choice.
CodexBash, , 6 min read
A spreadsheet-style table that stores everything in one place feels convenient until the same customer's address appears in three rows with three different spellings. Normalisation is the process of organising tables so that each fact is stored exactly once, which keeps data consistent and makes changes safe. It is described through a series of normal forms, each removing a particular kind of redundancy. This article works through them by fixing one badly designed table.
Sign in to read the rest
The whole 6 minute article is free with an account, along with every problem, lesson and tutorial. No card.