Companies

CompanyIDNameLocationID
1Airline X1
2Airline Y2
3Airline Z3
4Tech Co.4
5Health Care Inc.5

Locations

LocationIDCityStateCountry
1New YorkNYUSA
2ChicagoILUSA
3Los AngelesCAUSA
4LondonEnglandUK
5ParisFranceFR

Skills

SkillIDName
1Programming
2Data Analysis
3Network Administration
4Database Management
5Web Development

JobPostings

PostingIDTitleDescriptionMinSalaryMaxSalaryCompanyIDLocationIDAviation_JobsTraining_Center
(→ Companies.CompanyID)(→ Locations.LocationID)
1Software EngineerDevelop software applications60000.080000.011NoneNone
2Data AnalystAnalyze large datasets50000.070000.012NoneNone
3Network AdministratorMaintain network infrastructure55000.075000.023NoneNone
4Database ManagerManage databases60000.080000.034NoneNone
5Web DeveloperDesign and develop websites55000.075000.045NoneNone
6Flight AttendantAttend to passengers on flights35000.050000.011Flight AttendantAviation Academ
7Flight AttendantAttend to passengers on flights35000.050000.022Flight AttendantABC Aviation Academy
8Commercial PilotFly commercial aircraft60000.090000.011PilotAviation Academ
9Commercial PilotFly commercial aircraft60000.090000.023PilotXYZ Aviation Academy