See the Excel file. In it you will find a sample of data from a file that at some point will have to be made into a database.

Assumptions:

Assume that on any given day a flight can be uniquely identified by the combination of the airline code and the flight number.

An origin airport (e.g. LAX) may be used by multiple flights. An airport that is an origin for one flight may be a destination for another flight.

The sets of codes for origin and destination airports are the same, so there will be some data duplication in the table: Airport names will be listed as destinations and as origins.

An Origin (e.g. LAX) may be used by multiple flights. An airport that is an origin for one flight may be a destination for another flight.

The sets of codes for origin and destination airports are the same, so there will be some data duplication in the table: Airport names will be listed as destinations and as origins.

a. Bring the sample data into 1NF within Excel. Post a screen capture or JPG version in your answer document.

b. Draw a dependency diagram that shows all functional dependencies in the relation, based on the shown sample data. You can hand-draw or use any tool you like. Post it in your answer document.

c. Give an example of one or more anomalies that can result from using this relation.

Bring the relations to 2NF and show any remaining dependencies. You can hand-draw or use any tool you like. Post it in your answer document.

d. Develop a set of relations in 3NF. You can hand-draw or use any tool you like. Post it in your answer document.