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 1:00pm 3:00pm STL- St. Louis 57 04/02/13 6:00am 374 MCI-Kansas City 22 04/02/13 2:00pm