1. A database for Airline Operations Management System is intended to help in managing the assignments of aircrafts to various flights operated by several airlines. Each airline operates many flights daily. The operation of each flight is done by one airline only. A given flight usually starts from one airport and ends in another airport. Each airport has many flights arriving and many flights departing each day. An Airport is located in one city and each city may have one or more airports. To operate a flight in a given day, an aircraft is assigned to that flight. Each assignment includes one flight and one aircraft in a specific date. It is common that a flight will be assigned different aircrafts in different days. In other words, over a period of time, each flight will show in many assignments and each aircraft will have many assignments. a. b. c. Identify the entities of this database model. Extract the business rules that describe the relationships between the entities in the model Draw Entity Relationship Diagram for the database as described above using: . Crow's Foot notation Chen notation