Share
Explore BrainMass

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

Attachments

Solution Summary

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

$2.19