Question: A question about BCNF . Consider the relation scheme { pilot , flight, date, time } , with the following FDs: ( We use
A question about BCNF Consider the relation scheme pilot flight, date, time with the following FDs: We use to for the arrow.
flight to time
pilot,date,time to flight
flight,date to pilot
Which of the following statements are correct?
After decomposing on the first FD we are done with BCNF since both obtained parts are then in BCNF
If we decompose on the first FD we obtain the parts flighttime with FD flight to time, and flightdate,pilot with FD flight,date to pilot.
We can decompose on the third FD since its lefthand side is not a key.
If we decompose on the third FD we obtain the parts flightdate and pilottime
We can't decompose on the second FD since its lefthand side is a key.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
