Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following AIRLINE database schema shown in the Figure 5 . 8 , which describes a database for airline flight information. Each FLIGHT is
Consider the following AIRLINE database schema shown in the Figure which describes a database for airline flight information. Each FLIGHT is identifiedAIRPORT
FLIGHT
FLIGHTLEG
LEGINSTANCE
FARE
AIRPLANETYPE
CANLAND
AIRPLANE
SEATRESERVATION
Figure
The AIRLINE relational database schema. by a Flightnumber, and consists of one or more FLIGHTLEGs with Legnumbers and so on Each FLIGHTLEG has scheduled arrival and departure times, airports, and one or more LEGINSTANCEs one for each Date on which the flight travels. FAREs are kept for each FLIGHT. For each FLIGHTLEG instance, SEATRESERVATIONs are kept, as are the AIRPLANE used on the leg and the actual arrival and departure times and airports. An AIRPLANE is identified by an Airplaneid and is of a particular AIRPLANETYPE. CANLAND relates AIRPLANETYPEs to the AIRPORTs at which they can land. An AIRPORT is identified by an Airportcode.
Specify all the referential integrity constraints that hold on the schema in the following format:
Foreign key matches Primary Key
Example: Flightnumber of FLIGHT LEG matches Flightnumber of FLIGHT
The FKs and PKs are provided below.
FKs:
Flightnumber of FLIGHT LEG
Flightnumber of FARE
Flightnumber of LEGINSTANCE
Flightnumber of SEATRESERVATION
Arrivalairportcode of FLIGHTLEG
Departureairportcode of FLIGHTLEG
Airportcode of CANLAND
Legnumber of LEGINSTANCE
Legnumber of SEATRESERVATION
Airplanetypename of CANLAND
Airplanetype of AIRPLANE
Airplaneid of LEGSTANCE
PKs:
Flightnumber of FLIGHT
Legnumber of FLIGHT LEG
Airplane id of AIRPLANE
Legnumber of LEGINSTANCE
Airportcode of AIRPORT
Flightnumber of FLIGHTLEG
Airplanetypename of AIRPLANETYPE
Flight number of LEGINSTANCE
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