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.
go
