(Solved): - You are asked to draw a logical model using your choice of a drawing tool such as MS Word, Visio ...

- 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 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 3 NF 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.