1. Engineering
  2. Computer Science
  3. the following unnormalized database schema is given for a flight...

Question: the following unnormalized database schema is given for a flight...

Question details

The following unnormalized database schema is given for a flight booking system: BOOKING(FlightNr, CNr, Airline, Destination, DestinationCountry, Departure, FlightDate, BookingDate, Price, CName ) The schema contains the following functional dependencies (FDs): • (FD1) FlightNr → Destination , DestinationCountry • (FD2) FlightNr → Airline • (FD3) FlightNr → Departure • (FD4) Destination → DestinationCountry • (FD5) CNr → CName Two travel bookers use different strategies to determine the price for a ticket. Formulated in functional dependencies we have: • (FD6) FlightNr , BookingDate , FlightDate → Price • (FD7) Airline , Destination , BookingDate , FlightDate → Price Using these FDs and the inference rules F1-F6, verify whether (FD1-FD5) together with FD6 imply the dependency FD7 and, vice versa, whether (FD1- FD5) together with FD7 imply the dependency FD6. Are FD6 and FD7 equivalent?

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution