## Flight

flightID | departureTime | arrivalTime | aircraftID | terminalID
--- | --- | --- | --- | ---
|  |  | (→ Aircraft.aircraftID) | (→ Terminal.terminalID)
1 | 2023-01-01 07:00:00 | 2023-01-01 10:00:00 | 1 | 1
2 | 2023-01-01 09:00:00 | 2023-01-01 11:00:00 | 2 | 1
3 | 2023-01-01 11:00:00 | 2023-01-01 13:00:00 | 3 | 2
4 | 2023-01-01 14:00:00 | 2023-01-01 16:00:00 | 4 | 1
5 | 2023-01-01 16:00:00 | 2023-01-01 18:00:00 | 5 | 2

## Passenger

passengerID | firstName | lastName | flightID | loungeID
--- | --- | --- | --- | ---
|  |  | (→ Flight.flightID) | (→ Lounge.loungeID)
1 | John | Doe | 1 | 1
2 | Jane | Smith | 2 | 1
3 | Alice | Brown | 3 | 2
4 | Michael | Johnson | 4 | 1
5 | Emily | White | 5 | 2

## Aircraft

aircraftID | model | capacity
--- | --- | ---
1 | Airbus A320 | 200
2 | Boeing 737 | 180
3 | Embraer E190 | 100
4 | Airbus A380 | 500
5 | Boeing 777 | 350

## Terminal

terminalID | location
--- | ---
1 | Terminal 1
2 | Terminal 2

## Lounge

loungeID | name | exclusiveArea | amenities | capacity | terminalID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Terminal.terminalID)
1 | Business Class Lounge | Frequent Flyer Lounge | Complimentary Wi-Fi | 100 | 1
2 | Premium Economy Lounge | Frequent Flyer Lounge | Not Complimentary Wi-Fi | 80 | 1
3 | First Class Lounge | VIP Lounge | Complimentary Wi-Fi | 50 | 2
4 | Golden Wings Lounge | VIP Lounge | Not Complimentary Wi-Fi | 60 | 2
5 | Silver Stars Lounge |  |  | 40 | 1

## Amenity

amenityID | description
--- | ---
1 | Free high-speed internet access
2 | Power outlets at every seat
3 | Quiet zones for relaxation
4 | Children's play area
5 | Showers facilities