Database Technologies

Database normalization explained: 1NF, 2NF and 3NF

Database normalisation explained: how splitting data into tables stops duplication, what 1NF, 2NF and 3NF mean, a worked SQL example, and when to denormalise.

  • 7 min read
  • 5 questions
  • +35 XP
Transcript

Database Normalisation, explained by cats. Kitty runs a tuna shop. She stores orders in one big table. Customer name. Customer address. Tuna type. Tuna price. and Order date. Everything. in one table. One giant mess. So Kitty normalises her database.

Normalisation means splitting data into separate tables so each fact is stored once. Customers go in one table. Orders in another. Products in another. Now Fluffy’s address lives in one place. Order rows just point to Fluffy. Less duplication. Less inconsistency.

And Cleaner data. That’s database normalisation. Normalisation makes databases tidy. Reliable. And easy to update. Because one fact should not live in seventeen different tuna rows.