Airport

Database schema consists of 4 tables:

Company (ID_comp, name)
Trip (trip_no, id_comp, plane, town_from, town_to, time_out, time_in)
Passenger (ID_psg, name)
Pass_in_trip (trip_no, date, ID_psg, place)

Database Scheme

Company table has ID and name of the company, which transports passengers.

Trip table has information about trips: trip number, company ID, plane type, departure city, arrival city, departure time, and arrival time.

The Passenger table has passenger’s ID and passenger’s name.

Pass_in_trip table has information about the flights: trip number, departure date (day), passenger’s ID and his place during the flight. We should note that,

  • Any trip is being accomplished every day; duration of a flight is less than a calendar-day (24 hours);
  • Time and date are considered comparatively one time zone;
  • The departure time and the arrival time are given to within a minute;
  • There can be the passengers bearing the same names (for example, Bruce Willis);
  • The place during the flight is a number followed by a letter; the number defines the row number, the letter (a - d) – the place in the row (from the left to the right) in the alphabetical order;
  • Relationships and restrictions are shown in the data schema.