Normal forms and star schemas (with labeled diagrams), keys and constraints, B-tree indexes, EXPLAIN, isolation levels, SQL injection, NULL logic and common pitfalls.
Normal forms nest like rings. Which normal form is the outermost (least strict) one, the label hidden at the top?
Tap to flip
Back
Normal forms nest like rings. Which normal form is the outermost (least strict) one, the label hidden at the top?
1NF (first normal form): every column holds a single atomic value and there are no repeating groups. Every table that satisfies a higher normal form also satisfies 1NF.