Question: Draw a logical model using your choice of a drawing tool such as MS Word, Visio, or any tool you prefer ( you may draw

Draw a logical model using your choice of a drawing tool such as MS Word, Visio, or any tool you prefer ( you may draw by hand as well).
Review the flight information illustration shown below to draw the logical model. Question #1 Requirements: The Flight Information logical modeling
1. Identify and list all the tables
2. Assign the primary keys and foreign keys (where applicable) for each table
3. Normalize the completed diagram up to 3NF
4. Display the relationship type (e.g., 1:1, 1:M, or M:M)
5. Eliminate any occurrence(s) of the M: M relationship using a Join (Intersect) table. Assign the corresponding keys to this intersect table.

Traveler Name: Departure: Destination: Fare: Travel Information Flight Number 44 374 Gustavo Gomez SEA MCI

Traveler Name: Departure: Destination: Fare: Travel Information Flight Number 44 374 Gustavo Gomez SEA MCI $531.00 (includes Gov't taxes & fees) Destination STL-St. Louis MCI - Kansas City Gate Date 57 22 Seattle/Tacoma Kansas City, MO 04/02/13 04/02/13 Departure Time 6:00am 2:00pm Arrival Time 1:00pm 3:00pm

Step by Step Solution

★★★★★

3.36 Rating (146 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

ER diagram ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Verizon Communications Inc. had $13.44 billion in FCFF in the most recent year. If the firm's expected growth rate is 5%, its WACC is 10% and the cost of equity is 13%, what is the value of Verizon?

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

- You are asked to draw a logical model using your choice of a drawing tool such as MS Word, Visio, or any tool you prefer ( you may draw by hand as well). - Review the flight information...

The purpose of the semester-long group project is to give you an opportunity to put the theory of database modeling, implementation and application design into practice. The result will be a fully...

Can someone verify this as correct? Question #1.) Designing a Logical Model (20 points) - You are asked to draw a logical model using your choice of drawing tool such as MS Word, Visio or any tool...

Question #1.) Designing a Logical Model You are asked to draw a logical model using your choice of drawing tool such as MS Word, Visio or any tool you prefer. Review the flight information...

Business Scenario - Maintenance Process of Rental Cars : " The business process example starts with a customer filing an online complaint regarding problems with a car that they rented in the past....

This project requires you to complete a medical clinic case analysis in process modeling and mapping, Using Microsoft Word, write a verbal description of the activity as you understand it to...

Please read chapter 6 and answer the questions and see the ( guide to answer number 3) 1. Decide what assessment you would like to do to provide you with more information about the student, 2....

5. Gordon Company was recently formed with a $5,000 investment in the company by shareholders. The company then borrowed $2,000 from a bank, purchased $1,000 of supplies on account, and also...

What is the objective function of the dual maximization problem? Use u and v for the dual variables. OP=u+v O P = 4u + 7v OP= -4u 7v P= 45u + 40v O P= -45u - 40v

Packers Corporation, a public company, reports the following amounts in its first three years of operations: 2 0 0 3 2 0 0 4 2 0 0 5 Accounting income $ 1 6 0 , 0 0 0 $ 1 3 9 , 0 0 0 $ 1 3 1 , 0 0 0...

Schwedt Company issued $280,000 of 9%, 10-year bonds at face value on September 1, 2012. The bonds pay interest on March 1 and September 1. Schwedt uses the calendar year for financial reporting...

Silmaril, Inc., borrowed $25,000 from First National Bank by issuing a three-year, 10% note dated July 1, 2011. Interest is payable semiannually on December 31 and June 30. The principal amount is to...

1. Peg Corporation owns a 70 percent interest in San Corporation, acquired several years ago at book value. On December 31, 2011, San mailed a check for $20,000 to Peg in part payment of a $40,000...

Multinational transfer pricing, global tax minimization. Industrial Diamonds, Inc., based in Los Angeles, has two divisions: South African Mining Division, which mines a rich diamond vein in South...

Comparative statement data for Douglas Company and Maulder Company, two competitors, appear below. All balance sheet data are as of December 31, 2011, and December 31, 2010. Instructions (a) Prepare...

Name the vulnerable and special needs patients in your unit.

Abigail (Abby) Boxer is a single mother working as a civilian accountant for the U.S. Army. Her Social Security number is 676-73-3311 and she lives at 3456 Alamo Way, San Antonio, TX 78249. Helen,...

Matthew borrows $250,000 to invest in bonds. During 2012, his interest on the loan is $30,000. Matthew's interest income from the bonds is $10,000. This is Matthew's only investment income. a....

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-4. Ivan and Irene paid the following in 2012 (all by check or can otherwise be...

Based on the model N(1152, 84) describing Angus steer weights from Exercise 25, what are the cutoff values for a) The highest 10% of the weights? b) The lowest 20% of the weights? c) The middle 40%...

A large philanthropic organization keeps records on the people who have contributed. In addition to keeping records of past giving, the organization buys demographic data on neighborhoods from the...

The Virginia Cooperative Extension reports that the mean weight of yearling Angus steers is 1152 pounds. Suppose that weights of all such animals can be described by a Normal model with a standard...