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 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 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: Departure: Destination: Fare: Travel Information Gustavo Gomez SEA Seattle/Tacoma MCI Kansas City, MO $531.00 (includes Gov't taxes & fees) Flight Number 44 374 Destination Gate Date Departure Time STL-St. Louis 57 04/02/13 6:00am MCI - Kansas City 22 04/02/13 2:00pm Arrival Time 1:00pm 3:00pm Infoflight Flight_ID BIGINT(10) Airline_ID BIGINT(10) From_Location VARCHAR(20) To_Location VARCHAR(20) Arrival_Time DATE Departure_Time DATE Location_code VARCHAR(5) Durration_Of_Travel TIMESTAMP Indexes Flight_Details Airline_ID INT Ticket_ID BIGINT(10) Flight_Departure_Time TIMESTAMP * Gate INT Flight_Detailscol VARCHAR(45) + Ticket_Details Ticket_ID INT Airline_ID VARCHAR(45) Profile_ID VARCHAR(45) HO Flight_Departure_Time VA... Pasenger_Details_Profile_... Indexes Indexes Pasenger_Details Profile_ID INT First_Name VARCHAR(15) Last_Name VARCHAR(15) Address VARCHAR(45) Email VARCHAR(25) Phone_Number VARCHAR(15) Indexes