E/R Diagram for Flight Control System
Translated by
ScribdTranslationsE/R Diagram for Flight Control System
Translated by
ScribdTranslationsE/R Diagram.
Create a data model with an E/R diagram of the following situation:
Obtain the E/R diagram for a flight control system adapted to the
following management rules (indicate the entities, interrelations, etc., that are
they are deduced from each of the rules:
a) Each airport is known by its code, name, city, and country.
b) Various models of airplanes can land at each airport.
The model of an airplane determines its capacity, that is, the number of seats.
c) At each airport there is a collection of flight programs. In each
The flight program indicates the flight number, airline, and days of the week.
in which this flight exists.
d) Each flight program takes off from one airport and lands at another.
Flight numbers are unique worldwide.
f) At each airport, there are multiple landings and takeoffs. All airports
Those in operation are considered, meaning they have at least one landing and one takeoff.
g) Each flight undertaken belongs to a certain flight program. For each flight
They want to know the date, available seats, and the type of aircraft used.
h) Some flight programs include intermediate technical stops between the
departure and arrival airports. A technical stop is understood as a landing
and consecutive takeoffs without any passenger increases or decreases.
i) For each flight, the technical stopovers are to be known, assigning them to
each one a serial number. For example, Iberia flight program 555
with flights on Mondays and Thursdays departing from Barajas-Madrid-Spain and landing in
Caudell-Sydney Australia having the following technical stops:
1- Los Pradiñ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 they could go down on the scales or
boarding passengers?
Explain how this new situation could be represented.