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:
FLIGHT(flightnumber, flighttime, airlinename, passenger(passengername, gender, date_of_birth), pilot(pilotname, gender, date_of_birth), departure_city, arrival_city, airplane(planeID, type, seats))

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!