E/R Diagram for Flight Control System
Translated by
ScribdTranslationsE/R Diagram for Flight Control System
Translated by
ScribdTranslationsProblem 4
Obtain the E/R diagram for a flight control system adapted to the following rules.
of management (indicate the entities, interrelationships, etc., that are deduced from each of the
rules): a) The code, name, city, and country of each airport are known. b) In each
Various models of planes can land at the airport (the model of a plane
determine its capacity, that is, the number of seats. c) At each airport there is a
collection of flight programs. Each flight program indicates the flight number,
airline and days of the week when the flight exists. d) Each flight program takes off
from one airport and lands at another. e) Flight numbers are unique worldwide. f)
At each airport, there are multiple landings and takeoffs. All airports
are active, that is to say, they have some landing and some takeoff. g) Each flight
completed belongs to a certain flight program. For each flight, it is necessary to know its
date, empty seats and the type of aircraft used. h) Some flight programs include
intermediate technical stops between the departure and arrival airports. It is understood by
technical stop for consecutive landing and takeoff without high or low passenger numbers. i) From each
Flight wants to know the scheduled technical stops, assigning a number to each one.
Order. For example, Iberia flight program 555 with flights on Mondays and Thursdays departs
from Barajas Madrid-Spain and lands in Caudell-Sydney-Australia with the following layovers
técnicas: 1- Los P radiños-Sao Paulo-Brasil, 2-El Emperador-Santiago-Chile y 3-Saint Kitts-
Auckland-New Zealand. What changes will occur in the previous case if during the layovers
Could passengers get on or off? Explain how this new situation could be represented.