Normalisation

Transform the following entities into 1NF and 2NF entities. Draw the
original and final data models, and state any reasonable assumptions.
(Note: primary keys are underlined)

AIRCRAFT (AIRCRAFT ID NUMBER, AIRCRAFT CODE, AIRCRAFT DESCRIPTION,
NUMBER OF SEATS)

FLIGHT (FLIGHT NUMBER, DEAPRTURE CITY, 1{ARRIVAL CITY} n, MEAL CODE,
1{FLIGHT DATE, CURRENT SEAT PRICE}m )

PASSENGER (PASSENGER NUMBER, PASSENGER NAME, FREQUENT FLYER NUMBER,
1{FLIGHT NUMBER, SEAT NUMBER, QUOTED SEAT PRICE, AMOUNT PAID, BALANCE
DUE} )