Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Example: students can take many courses, taught by one teacher per course -- (student, course) -> teacher [teacher depends on course] -- teacher -> course [teacher determines course] -- PK is (student, course) but teacher -> course violates BCNF -- Fix: separate course_teachers table -- course_id -> teacher_id
Result
Open