Reference no: EM133278062

Develop an Entity-Relationship diagram for Scoundrel Airline's database for flight information and reservations.

Scoundrel Airlines wants to keep information on its airplanes. They want to record the airports that they fly into and out of. Airport information should include the airport's code (such as 'RIC' for the Richmond-Williamsburg International Airport), the name of the airport, the primary city it serves, and in which state or province it is. The database should keep track of the types of airplanes that the Airline owns, capturing the information of the number of seats, the manufacturer, and the model name. The database should model the fact that only certain types of airplane can land at certain airports. For instance, jumbo jets can land at RIC, but not at the Newport News-Williamsburg International Airport (PHF). Every airplane is of a given airplane type. The database needs to keep track of flights. A leg of a trip is denoted by its departure information (from airport X, departure time) and its arrival information (to airport Y, arrival time). A particular airplane is assigned to a given flight leg on a given day. Each flight leg has a number of seats available to be reserved. Each seat on the airplane is reserved for a given customer, recording his or her name and telephone number. A flight is made up of a sequence of legs, for which they want to record the flight number, the flight fare, and whether the flight flies on weekdays or not.