In this assignment, you should model a simplified flight management system with the

following requirements: Each flight has a unique flight number, a date, a departure location, destination, and an airline operating the flight. For example, the flight with the identifier DBO$20$ takes place on July $20,2022,$ flies from Hamburg to New York and is operated by the airline DBAir. For each flight an aircraft is assigned. Every aircraft has a unique identifier and a number of seats. Furthermore, one crew is assigned for each flight. The crew exists specifically for this flight and contains the first name and last name of the chief pilot and the first name and last name of the purser. A passenger can book tickets for several flights, every ticket price can be different as it depends on the booking date, the flight, the flight load, etc..

Q$)$Create an Entity$-$Relationship$-$Diagram $($ERD$)$ in MC notation that captures the described information and is designed in a slim and thought$-$out way. The Entity$-$Relationship$-$Diagram should consist of entity types, attributes, relationship types, and cardinalities in MC notation. Please indicate possible identifying attributes, multivalued attributes, derived attributes, and compound attributes if any. Use given keywords as names for entity types, attributes, and relationship types and find appropriate attributes and names, when needed. Explain the cardinalities of the relationships.