Skip to main content

3NF

Learn 3NF (Normalization, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction A table is in Third Normal Form when it is in 2NF and no non-key column depends on another non-key column (no transitive dependency). Memory aid: every attribute depends on the key, the whole key, and nothing but the key.

More lessons in Normalization