BCNF check with decomposition
SQL
Medium
3 views
Problem Description
Table Teaching(teacher, subject, room). Rule: each subject is taught in exactly one room, but a teacher can teach many subjects. Show BCNF decomposition in SQL.
Output Format
DDL statement(s)
Sample Test Case
Input:
Teaching(teacher, subject, room)
Output:
Decomposed tables
Constraints
subject -> room violates BCNF
Official Solution
CREATE TABLE SubjectRooms (subject VARCHAR(100) PRIMARY KEY, room VARCHAR(50) NOT NULL); CREATE TABLE TeacherSubjects (teacher VARCHAR(100) NOT NULL, subject VARCHAR(100) NOT NULL, PRIMARY KEY(teacher, subject));
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!