Skip to content

In 3NF but not BCNF

Teaches(student, course, teacher) with these rules:

  • a student takes a course from exactly one teacher: {student, course} → teacher
  • each teacher teaches exactly one course: teacher → course

Candidate keys are {student, course} and {student, teacher}.

Is this in 3NF, BCNF, both, or neither?