Companies

CompanyIDCompanyName
1ABC Corporation
2XYZ Limited
3PQR Enterprise

Locations

LocationIDLocationName
1New York City
2Los Angeles
3Chicago

Jobs

JobIDJobTitleDescriptionCompanyID
(→ Companies.CompanyID)
1Software EngineerDesigns and develops software applications.1
2Data AnalystAnalyzes and interprets complex datasets.2
3Project ManagerManages project scope, time, cost, quality, resources, risks, communications, procurements, integration, stakeholder engagement, and closure.3

SalaryRanges

SalaryRangeIDMinimumSalaryMaximumSalary
160000.080000.0
270000.090000.0
350000.070000.0

JobSkills

JobSkillIDSkillName
1Python
2Java
3SQL

JobDetails

DetailIDJobIDSalaryRangeIDJobSkillID
(→ Jobs.JobID)(→ SalaryRanges.SalaryRangeID)(→ JobSkills.JobSkillID)
1111
2222
3333

RealEstateJobs

RealEstateJobIDCommissionRateJobTypeAdditionalInfoJobID
(→ Jobs.JobID)
15%Real Estate Agent1
27%Real Estate Agent2
35%Property Manager3
46%Property Manager4