Database for airport
- Airlines table: IDs and names of the airlines
- Flight table: trip (flight) number, company (airline) ID, plane type, departure city, destination city, departure time, and arrival time.
- Passenger table: IDs and names of the passengers.
- Bookings table: trip number, departure date (day), passenger ID and her seat (place) designation during the flight.
Note: all time and date values are assumed to belong to the same time zone