1. Normalize the following relation into BCNF. Show all your work, including intermediate steps through 1NF and 2NF. Indicate the primary and foreign key attributes. Justify your answer.

R(flightnumber, flighttime, airline(airlinename), passenger(passengername, gender, date_of_birth), pilot(pilotname, gender, date_of_birth), departure_city, arrival_city, airplane(planeID, type, seats))

First Normal Form:

Second Normal Form:

BoyceCodd Normal Form: