Draw an E-R diagram that models the following situation:

You were hired to maintain a database for an airport management company. They keep track of multiple airports, each of which has a unique code, the name of the city where the airport is located and a listing of the available terminals (at least one, possibly more). Every airport serves a number of different airlines. For each airline we keep track of the airline name that uniquely identifies the airline and the name of its CEO. Each airport has at least one gate. Gates do not have a unique identifier, but they do have individual numbers assigned to them within each particular airport. For every gate also store the capacity (number of waiting passengers). In all of the airports we have a number (at least 10) of bag handlers assigned to the airport. Each bag handler has a SSN for identification and a name. All new bag handlers are assigned a supervisor from one of the more senior colleagues. Senior bag handlers are, in turn, supervised by more senior colleagues. No employee is supervised by more than one person.