Question
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
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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started