## Gate_Agents

ID | Name | Language | YearsOfExperience | LicenseNumber
--- | --- | --- | --- | ---
1 | Juan | Spanish | 8 | A0923
2 | Emily | English | 7 | B1263
3 | Michael | French | 6 | C3456
4 | Olivia | German | 5 | D5678
5 | Liam | Italian | 4 | E7890

## Pilots

ID | Name | Language | FlightHours | LicenseNumber
--- | --- | --- | --- | ---
1 | Alberto | Spanish | 2000 | F0011
2 | David | English | 1800 | G0022
3 | Isabelle | French | 1600 | H0033
4 | Leo | German | 1400 | I0044
5 | Milan | Italian | 1200 | J0055

## Airlines

ID | Name | Code | Headquarters
--- | --- | --- | ---
1 | American Airlines | AA | Fort Worth, Texas
2 | United Airlines | UA | Chicago, Illinois
3 | Delta Airlines | DL | Atlanta, Georgia
4 | Southwest Airlines | WN | Dallas, Texas
5 | Spirit Airlines | NK | Miramar, Florida

## Flights

ID | AirlineID | DepartureTime | ArrivalTime | DestinationAirport
--- | --- | --- | --- | ---
| (→ Airlines.ID) |  |  |
1 | 1 | 2023-04-01 10:00:00 | 2023-04-01 12:00:00 | New York JFK
2 | 2 | 2023-04-01 11:00:00 | 2023-04-01 13:00:00 | Los Angeles LAX
3 | 3 | 2023-04-01 12:00:00 | 2023-04-01 14:00:00 | Atlanta Hartsfield-Jackson
4 | 4 | 2023-04-01 13:00:00 | 2023-04-01 15:00:00 | Dallas Love Field
5 | 5 | 2023-04-01 14:00:00 | 2023-04-01 16:00:00 | Fort Lauderdale Hollywood

## Passengers

ID | FirstName | LastName | Age | Nationality
--- | --- | --- | --- | ---
1 | John | Smith | 30 | USA
2 | Jane | Doe | 25 | UK
3 | Tom | Brown | 40 | Canada
4 | Anna | White | 35 | Australia
5 | Paul | Green | 45 | France

## Baggage

ID | FlightID | OwnerID | Weight | Description
--- | --- | --- | --- | ---
| (→ Flights.ID) | (→ Passengers.ID) |  |
1 | 1 | 1 | 10 | Laptop bag
2 | 1 | 2 | 15 | Skis case
3 | 2 | 3 | 20 | Golf clubs
4 | 2 | 4 | 25 | Musical instruments
5 | 3 | 5 | 30 | Stroller