3. Consider the following requirements of a database for airline flight information system. a. Each flight...

 

Transcribed Image Text:

3. Consider the following requirements of a database for airline flight information system. a. Each flight is identified by a flight number, the weekdays it operates on, and consists of one or more flight legs. A flight leg is a nonstop portion of a flight. b. Each flight leg of a particular flight is identified by a number 1, 2, 3, etc., its scheduled arrival and departure times and arrival and departure airports. The flight leg is associated with many instances of that leg one for each date on which the flight travels. The leg number is unique for flight legs of the same flight. Each instance of the flight leg is recorded, along with the airplane used, and the actual arrival and departure times. Fares are kept for each flight. Each fare has a type (business, economy, charter, a price associated with each fare type for each flight leg. C. d. Each airport has code (unique), name, (unique), and city. ), and e. Airplanes have different types that are identified by their name (e.g. Boeing, Airbus, etc.), the manufacturer, and the number of seats on board for each fare type. Different airports only allow certain airplane types to land. f. Each airplane has a number that is unique for airplanes of the same type, an airplane type, technical status (in service, out of service, maintenance, etc.) Design a database for the airline information system described above. (15 points) 3. Consider the following requirements of a database for airline flight information system. a. Each flight is identified by a flight number, the weekdays it operates on, and consists of one or more flight legs. A flight leg is a nonstop portion of a flight. b. Each flight leg of a particular flight is identified by a number 1, 2, 3, etc., its scheduled arrival and departure times and arrival and departure airports. The flight leg is associated with many instances of that leg one for each date on which the flight travels. The leg number is unique for flight legs of the same flight. Each instance of the flight leg is recorded, along with the airplane used, and the actual arrival and departure times. Fares are kept for each flight. Each fare has a type (business, economy, charter, a price associated with each fare type for each flight leg. C. d. Each airport has code (unique), name, (unique), and city. ), and e. Airplanes have different types that are identified by their name (e.g. Boeing, Airbus, etc.), the manufacturer, and the number of seats on board for each fare type. Different airports only allow certain airplane types to land. f. Each airplane has a number that is unique for airplanes of the same type, an airplane type, technical status (in service, out of service, maintenance, etc.) Design a database for the airline information system described above. (15 points)