Technology LearningCheat Sheet
DATABASECHEAT SHEETS
SHEET 08
Normalization from 1NF to 5NF
M.R. Sterling
Database Advanced · Sheet 08
Normalization from 1NF to 5NFSQLite
The full ladder from 1NF to 5NF. A table that passes 3NF but fails BCNF, fixed and guarded by SQLite, a lossless split proven with EXCEPT, a lossy one that invents rows, then 4NF and 5NF, each checked by joining the pieces back.
$4.50Get this sheet
Or get all 6 in the Database Cheat Sheets: Advanced Pack for $19, or with the whole Health Data Clinic series in the Health Data Clinic - Complete + Cheat Sheets for $109.
Instant PDF downloadsent the moment you pay
Two A4 pagesprint front and back
SQLiteevery query runs as printed
Keep it foreverno expiry, no account
What the sheet looks like
A blurred preview, to show the layout and how much fits on the two pages. The full, print-sharp sheet comes with your download.
What is on this sheet
The full ladder
Candidate keys and determinants
Five dependencies
The BCNF test
Fix BCNF
Lossless join
A lossy split
MVD and 4NF
Join dependency and 5NF
The books this sheet pairs with
The sheet reminds you. These books teach it, one idea at a time, with every example worked.
More Database Advanced sheets
One email when a new book lands
No schedule, no filler. Just the new titles and the odd free chapter.