Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions