3. (20 pts) Draw an ERD for the following problem with attributes, primary keys, cardinality, and participation constraints. Use generalization/specialization. You may use either UML or Elmasrj and Navathe's notation. If you do not us one of the above two notations, make the meaning of your notations clear This is a simplified problem about an airline company. A small airline company, called Wonder Airline Company (WAC), is operated among several regional airports in the east coast area. They operate only nonstop direct flights without stopping in the middle. WAC has several flights, and each flight has flight#, daily flight time (departure time and arrival time), and #passengers allowed in the flight. A flight daily leaves one airport and arrives at a particular destination airport in another city (beach flight flies only once each day at the same time. Each airport 1s identified by three letter airport name such as JFK or PHL. Each airport also has a full name such as New York and Philadelphia and airport type such as Domestic or International. WAC needs to keep track of the number of passengers each flight instance carries. Each flight instance is identified by flight# and the date it flies. In each specific flight, there are four types of personnel in WAC. The personnel are pilot, attendants, and security. Each personnel has a unique ID name, and salary. Pilots have the number of flight hours and the number of years as a pilot in his/her career. Attendants need to have a flight class they can serve. Securities have a martial art type at which they are good and a gun license number. Different personnel could be assigned to a different instance of the same flight. To simplify, ignore all other issues. Note you may add more information than stated above, but you must include at least all the information stated in the above problem statement and your new assumption must not contradict to the above statements