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.

 

Transcribed Image Text:

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

Answer rating: 100% (QA)

ER diagram ... View the full answer