Explore BrainMass

Explore BrainMass

    Transform the following entities into 1NF and 2NF entities

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

    See the attachment for the problem.
    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, DEPARTURE 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}).

    © BrainMass Inc. brainmass.com February 24, 2021, 2:27 pm ad1c9bdddf
    https://brainmass.com/computer-science/databases/transform-following-entities-entities-21981

    Attachments

    Solution Summary

    This solution goes through step by step explanation and demonstration regarding transforming the entities into 1NF and 2NF entities.

    $2.19

    ADVERTISEMENT