Study Kasus
For each airplane we keep track of its identity, number of seats,
and type. Its type is defined by the name, the maximum number of seats, and the
company that produces it. Specific airplane types can land at specific
airports. For each airport we need to know the name, the city, the state, and
the code of it. Each flight has information about the airline, the number and
the weekdays it operates. It also has fares, with code number, amount, and
restrictions. A flight has several flight legs (a flight leg is for example
Aalborg-Copenhagen, and Copenhagen-New York, when you are flying from Aalborg
to New York via Copenhagen), from and to an airport, with scheduled departure
and arrival time respectively. Each airplane is assigned to a leg instance,
which is a particular occurrence of a flight leg on a particular date, while a
leg is a non-stop portion of a flight. Each leg instance arrives to and departs
from airport at specific arrival and departure times. Finally, for each leg
instance we can make reservations of seats, based on the customer name and
customer phone number.
