## Companies

CompanyID | CompanyName
--- | ---
1 | ABC Corporation
2 | XYZ Limited
3 | PQR Enterprise

## Locations

LocationID | LocationName
--- | ---
1 | New York City
2 | Los Angeles
3 | Chicago

## Jobs

JobID | JobTitle | Description | CompanyID
--- | --- | --- | ---
|  |  | (→ Companies.CompanyID)
1 | Software Engineer | Designs and develops software applications. | 1
2 | Data Analyst | Analyzes and interprets complex datasets. | 2
3 | Project Manager | Manages project scope, time, cost, quality, resources, risks, communications, procurements, integration, stakeholder engagement, and closure. | 3

## SalaryRanges

SalaryRangeID | MinimumSalary | MaximumSalary
--- | --- | ---
1 | 60000.0 | 80000.0
2 | 70000.0 | 90000.0
3 | 50000.0 | 70000.0

## JobSkills

JobSkillID | SkillName
--- | ---
1 | Python
2 | Java
3 | SQL

## JobDetails

DetailID | JobID | SalaryRangeID | JobSkillID
--- | --- | --- | ---
| (→ Jobs.JobID) | (→ SalaryRanges.SalaryRangeID) | (→ JobSkills.JobSkillID)
1 | 1 | 1 | 1
2 | 2 | 2 | 2
3 | 3 | 3 | 3

## RealEstateJobs

RealEstateJobID | CommissionRate | JobType | AdditionalInfo | JobID
--- | --- | --- | --- | ---
|  |  |  | (→ Jobs.JobID)
1 | 5% | Real Estate Agent |  | 1
2 | 7% | Real Estate Agent |  | 2
3 | 5% | Property Manager |  | 3
4 | 6% | Property Manager |  | 4