We use analytics cookies.We use cookies to analyze site traffic and improve your experience.
Loading...
System Design Masterclass · Database Fundamentals
Free preview: the first 2 parts of this 8-part lesson.
Already bought the course? Sign in to read the whole lesson.
this lesson is part of
System Design Masterclass
Unlock this lesson and the 751 other paid lessons
$25 once, by PayPal
See the System Design courseread the rest of this lesson in
System Design Masterclass
Unlock this lesson and the 751 other paid lessons
$25 once, by PayPal
See the System Design coursein Database Fundamentals
This lesson is part of the full System Design Masterclass. Unlock it along with 769 other lessons for a one-time payment.
One-time payment by card or PayPal
Get Lifetime AccessOne-time payment: UPI, card or netbanking
Get Lifetime Access18 Foundation lessons are free, no payment needed. Try them now
It is easy and good
“It is really nice and good Please join the course”
Normal forms are usually taught as definitions to memorise, which is why almost nobody can say what actually breaks when you ignore them. Every one of the three is the same instruction: record each fact in exactly one place.

One million orders built twice from identical source data, once flat and once normalised, in a real PostgreSQL.
The reason is measurable, which is what makes the rules usable. A fact stored in many places costs many writes to change and can end up disagreeing with itself.

The customers and products are generated once and both schemas are built from them, so nothing about the comparison depends on the data being different.

The flat table carries the customer's name, email and city and the product's name and category on every order row. The normalised schema carries two integers instead.
Each customer's details appear about fifty times in the flat table and exactly once in the normalised one. That ratio is set by how many orders a customer places, so it grows with the business.

Nothing about the flat table is wrong on the day it is created. It becomes wrong the first time one of those fifty writes does not land.