🗃️Database Normalization
Also known as Normalization, Normal Form, Normalisation
Setting up a database so each fact is kept in one place.
Think of it like
Think of it like one phone book for the whole house. Change a number once, and it is right for all.
Example
Jack's orders table copied each buyer's address. When Lucy moved, half her orders showed the old one. Moving addresses to the customers table fixed it.
Why it matters
Copied data drifts apart. When there is just one copy, it cannot.
Definition
Common mistake
Key takeaways
- 1One fact, one place. No copies to drift apart.
- 2Link, do not copy. Keys point to the one copy.
- 3Third form is enough. Most apps stop there.