Build an ER model to manage an airport with the following requirements: • A flight consists of one or more flight legs, flight legs belong to one flight. Flight legs start at one airport and end at...

Build an ER model to manage an airport with the following requirements:

• A flight consists of one or more flight legs, flight legs belong to one flight. Flight legs start at one airport and end at another airport.

• Flight legs are parts of a daily flight leg combination. A daily flight leg combination is assigned to one aircraft type and an aircraft type is assigned to one daily flight leg combination.

• An aircraft type can land at several airports.