What is Normalisation?
Storing each fact in exactly one place, and linking to it from elsewhere, so copies can't drift out of date.
Learn it properly
Chapter 9: The Diwali Dress Rehearsal
Database design that stays fast: schemas, indexes, N+1
Read chapter 9 →