Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started