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} )