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.