Interactive Normalization Checker

Drag attributes between tables to see which normal form is violated. The goal is to reach 3NF (or BCNF).

enrollments

PK: (student_id, course_id)

students

PK: student_id

courses

PK: course_id

Normal Form Check

Tip: Drag student_name into the students table and course_title + instructor into the courses table to reach 3NF.