Skip to main content

2NF

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

Introduction A table is in Second Normal Form when it is in 1NF and no non-key column depends on part of a composite key. In order_flat the key is (order_id, product_id), but product_name depends only on product_id, a partial dependency. Fix it by moving that data to its own table.

More lessons in Normalization