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
Post a Comment