Member Avatar for thompsonSensibl

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.

  • 2 Contributors
  • 1 Reply
  • 86 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by Divyab
Member Avatar for Divyab

Boyce Codd normal form helps in removing the deletion, updation and insertion anomalies.
In BCNF we decompose the FD's in a way that we divide the relation giving us the details into two tables depending upon the primary keys
Take an example

X,Y->Z
Z->Y

The above FD's are a type of BCNF
so to reslove this we make two tables

Table 1: X Y
Table 2: Y Z
Thus the anomalies are resolved.

Take this example you will b able to solve the question

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.