I'm having trouble finding the Boyce-Codd Normal Form (BCNF) decompositions of the relation schema: SCHEDULE.
SCHEDULE = {course, teacher, time, room}
Functional Dependencies (FD): course -> teacher, course, time -> room, teacher, time -> room.
Please help me decompose with respect to the FDs, that are faithful and unfaithful!
.
.
.
And FYI, I have tried, but failed to get the faithful one...
Cheers.