## Companies

CompanyID | Name | LocationID
--- | --- | ---
1 | Airline X | 1
2 | Airline Y | 2
3 | Airline Z | 3
4 | Tech Co. | 4
5 | Health Care Inc. | 5

## Locations

LocationID | City | State | Country
--- | --- | --- | ---
1 | New York | NY | USA
2 | Chicago | IL | USA
3 | Los Angeles | CA | USA
4 | London | England | UK
5 | Paris | France | FR

## Skills

SkillID | Name
--- | ---
1 | Programming
2 | Data Analysis
3 | Network Administration
4 | Database Management
5 | Web Development

## JobPostings

PostingID | Title | Description | MinSalary | MaxSalary | CompanyID | LocationID | Aviation_Jobs | Training_Center
--- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Companies.CompanyID) | (→ Locations.LocationID) |  |
1 | Software Engineer | Develop software applications | 60000.0 | 80000.0 | 1 | 1 | None | None
2 | Data Analyst | Analyze large datasets | 50000.0 | 70000.0 | 1 | 2 | None | None
3 | Network Administrator | Maintain network infrastructure | 55000.0 | 75000.0 | 2 | 3 | None | None
4 | Database Manager | Manage databases | 60000.0 | 80000.0 | 3 | 4 | None | None
5 | Web Developer | Design and develop websites | 55000.0 | 75000.0 | 4 | 5 | None | None
6 | Flight Attendant | Attend to passengers on flights | 35000.0 | 50000.0 | 1 | 1 | Flight Attendant | Aviation Academ
7 | Flight Attendant | Attend to passengers on flights | 35000.0 | 50000.0 | 2 | 2 | Flight Attendant | ABC Aviation Academy
8 | Commercial Pilot | Fly commercial aircraft | 60000.0 | 90000.0 | 1 | 1 | Pilot | Aviation Academ
9 | Commercial Pilot | Fly commercial aircraft | 60000.0 | 90000.0 | 2 | 3 | Pilot | XYZ Aviation Academy