Given the following assumptions: 

normalize the following relation:

Flight (Flightnumber, Flighttime, airline (airlinename), passenger (passengername, gender, date of birth), pilot (pilotname, gender, date of birth), departure_city, arrival_city, airplane (planeID, type, seats))

Transcribed Image Text:

• a flight has a unique flight number, a passenger has a unique name, a pilot has a unique name; a flight is always handled by one airline; a flight can have multiple passengers, a passenger can be on multiple flights; • a flight has one pilot, a pilot can operate multiple flights; • a flight is always handled by exactly one airplane;