Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

Need help normalizing functional dependencies FD to Boyce-Codd normal form BCNF

A relation schema has the following functional dependencies that I need to change into BCNF;

• {Student ID} → {Student name, Student email, Student address, Student phone};
• {SchoolBus ID} → {District, Departure, Destination, Transit Duration};
• {District, Departure, Destination, BusModel} → {Seats};
• {Booking No} → {Booking Date, Travel Date, SchoolBus ID};
• {Booking No, Student name} → {Price, BusModel}.

I have determined that StudentID, SchoolBus ID and Booking No are the keys. And im not sure how to change {District, Departure, Destination, BusModel} → {Seats} into BCNF because it doesn’t have a key in it. What I have done so far is this, but im not sure if it is correct. All help is appreciated! I’m having a hard time putting BCNF into practice

R1 {Student ID, Student name, Student email, Student address, Student phone}
R2 {SchoolBus ID, District, Departure, Destination, Transit Duration}
R4 {District, Departure, Destination, BusModel, Seatss}
R5 {Booking No, Booking Date, Travel Date, SchoolBus ID}
R6 {Booking No, Student name, Price, BusModel}
R7 {Booking No, SchoolBus ID, Student ID}

Im even having trouble finding examples of similar questions to work off... i am really stuck!

Comments