Transform the following entities into 1nf and 2nf entities

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

Solution Preview : View Answer

Prepared by a verified Expert
Database Management System: Transform the following entities into 1nf and 2nf entities
Reference No:- TGS01259681
Purchase Solution File

Now Priced at $30 (50% Discount)

Recommended (99%)

Rated (4.3/5)