Air West Airlines is a regional carrier that operates primarily in the southwestern United States. Draw an ER diagram to capture the following information in a database for the airline company. An airport is identified by a unique airport code and has a location which consists of (city, state), an elevation, and one or more phone numbers. An airport may have several flights to arrive at it and depart from it. A flight has a unique flight number, a base fare, and the number of seats. A flight can arrive at one or more airports and depart from one or more airports. For each arrival, the scheduled arrival time should be recorded. For each departure, the scheduled departure time should be recorded. Each flight has one or more staff members in its crew. Each staff member (who may be an attendant or a pilot, but not both) has a unique ID number, a name, and a hire date. A staff member may be assigned to several flights. Each flight attendant has a date for an advanced certification. Each pilot has a date for last physical examination. A flight attendant may be sponsored (a mentorship program) by another flight attendant. A flight attendant may be the sponsor of several other flight attendants. Each passenger has a unique itinerary number and a name. An attendant may serve meals for a passenger at several flights. A passenger can be served meals at a flight by at most one attendant. An attendant may serve meals for several passengers at a flight. An attendant must serve meals for at least one passenger at some flight. Some flight may not provide any meals, and some passenger may not want any meal services.
Air West Airlines is a regional carrier that operates primarily in the southwestern United States. Draw an ER diagram to capture the following information in a
Step by step
Solved in 2 steps with 1 images
