Database DesignNormalizationLesson 23 / 69

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.