[bcnf] Forum Topics

For each of the following sets of functional dependencies on a schema r(A, B, C, D, E) AB --> C, D --> E, B --> E A --> CD, B --> DE AB --> C, C --> D For each of the above set of functional dependencies, decompose relation r …

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! . …