Explore BrainMass
Share

Explore BrainMass

    NORMALISATION

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Transform the following entities into 3NF entities. Draw the original and final data models, and state any reasonable assumptions.

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

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

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

    © BrainMass Inc. brainmass.com October 9, 2019, 4:05 pm ad1c9bdddf
    https://brainmass.com/computer-science/programming-languages/normalisation-21897

    Attachments

    $2.19