Flights

flightIDoriginAirportIDdestinationAirportIDdepartureDatearrivalDateflightCategoryboardingTime
(→ Airports.airportID)(→ Airports.airportID)
1122023-07-18 09:002023-07-18 16:00International Flight10:00
2132023-07-19 08:002023-07-19 15:00International Flight09:30
3122023-07-20 09:002023-07-20 16:00Domestic Flight10:00
4452023-07-21 08:002023-07-21 15:00Domestic Flight10:30
5162023-07-22 10:002023-07-22 17:00Regional Flight09:30
6232023-07-23 09:002023-07-23 16:00Charter Flight11:00
7312023-07-24 08:002023-07-24 15:00Private Jet12:00

Passengers

passengerIDfullNamedateOfBirth
1John Doe1990-01-01
2Jane Smith1985-06-15
3Michael Johnson2000-09-03
4Emily Davis1992-10-20
5David Brown1988-12-05

Planes

planeIDmodelcapacity
1Boeing 747400
2Airbus A380800
3Embraer E195110
4Bombardier CRJ70065
5Gulfstream G65015

StaffMembers

staffMemberIDfirstNamelastNameposition
1AliceAdamsPilot
2BobSmithCo-pilot
3CarolJohnsonCustomer Service Agent
4DaveWilliamsManager
5EvaJonesMaintenance Technician

Bookings

bookingIDflightIDpassengerIDbookedByStaffMemberIDbookedAt
(→ Flights.flightID)(→ Passengers.passengerID)(→ StaffMembers.staffMemberID)
11112024-03-07 22:47:19
22212024-03-07 22:47:19
33322024-03-07 22:47:19
44432024-03-07 22:47:19
55542024-03-07 22:47:19

Assignments

assignmentIDplaneIDassignedToStaffMemberIDstartDateTimeendDateTime
(→ Planes.planeID)(→ StaffMembers.staffMemberID)
1112023-07-22 07:002023-07-22 16:00
2222023-07-23 06:002023-07-23 15:00
3332023-07-24 05:002023-07-24 14:00
4442023-07-25 06:002023-07-25 15:00
5552023-07-26 05:002023-07-26 14:00