Crowdly
Add to Chrome
Consider: AIRLINE_RESERVATION (PassengerID, FlightID, FlightDate, PassengerN...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Consider:AIRLINE_RESERVATION(PassengerID, FlightID, FlightDate, PassengerName, FlightNo, AirlineID, AirlineName, Source, Destination, SeatNo, TicketPrice, PilotID, PilotName)FDs:• PassengerID → PassengerName • FlightID → FlightNo, AirlineID, Source, Destination • AirlineID → AirlineName • FlightID, FlightDate → PilotID • PilotID → PilotName • FlightID → TicketPrice • PassengerID, FlightID, FlightDate → SeatNo What is the candidate key?
0%
0%
0%
100%