Draw an ER diagram that represents the following: An airline company employs many employees. Some are supervisors. Others are supervisees. The company assigns employees (e.g. pilots, flight attendants) to flights. A flight is assigned an airplane. Passengers buy tickets to get on a flight. They also choose a seat. They have a right to cancel their tickets a day before the departure time of the flight