Question: Given the following assumptions: a flight has a unique flight number, a passenger has a unique name, and a pilot has a unique name; a
Given the following assumptions:
a flight has a unique flight number, a passenger has a unique name, and a pilot has a unique name;
a flight is always handled by one airline;
a flight can have multiple passengers and a passenger can do multiple flights;
a flight has one pilot and a pilot can do multiple flights;
a flight is always handled by exactly one airplane;
normalize the following relation up to BCNF:
FLIGHTflightnumber flighttime, airlinename, passengerpassengername gender, dateofbirth pilotpilotname gender, dateofbirth departurecity, arrivalcity, airplaneplaneID type, seats
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
