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