Transform the following entities into 1NF and 2NF entities
Not what you're looking for?
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}).
Purchase this Solution
Solution Summary
This solution goes through step by step explanation and demonstration regarding transforming the entities into 1NF and 2NF entities.
Purchase this Solution
Free BrainMass Quizzes
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.