(Databases) Please answer clearly. A thumbs up for the right answer.

6. Given the following assumptions: 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 fight has one pilot, a pilot can operate multiple flights; A flight is always handled by exactly one airplanes; Normalize the following schema to a set of relations in 3NF: Flight (Flightnumber, Flighttime, airline(airlinename), passenger(passengername, gender, date of birth), pilot(pilotname, gender, date of birth), departure_city arrivial_city, airplane (planeID, type, seats)) When you develop a set of the relations, clearly denote primary key (and foreign key) specifications