1NF, 2NF, 3NF
Fill-gap30 min
1NF, 2NF, 3NF
Three pass/fail rules, each fixing what the previous allows:
- 1NF — no lists in cells. One value per column per row. A
phone_numbers
cell holding "012, 013" is out.
- 2NF — no fact depends on part of a composite key. In
(student_id, course_id, course_name), course name depends only on course_id — move it out.
- 3NF — no fact depends on a non-key column. If
zip → city, city belongs
in a zip table, not repeated in every address.
You reach 3NF mostly by noticing "wait, this column describes that key, not this row" and moving it. The forms are not ceremony — they are that sentence, three times.
Exercise
Normalize to 3NF: enrollments(student_id, student_name, course_id, course_title, instructor, instructor_email). Show each step and name the form.