| CompanyID | CompanyName |
|---|---|
| 1 | ABC Corporation |
| 2 | XYZ Limited |
| 3 | PQR Enterprise |
| LocationID | LocationName |
|---|---|
| 1 | New York City |
| 2 | Los Angeles |
| 3 | Chicago |
| 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 |
| SalaryRangeID | MinimumSalary | MaximumSalary |
|---|---|---|
| 1 | 60000.0 | 80000.0 |
| 2 | 70000.0 | 90000.0 |
| 3 | 50000.0 | 70000.0 |
| JobSkillID | SkillName |
|---|---|
| 1 | Python |
| 2 | Java |
| 3 | SQL |
| DetailID | JobID | SalaryRangeID | JobSkillID |
|---|---|---|---|
| (→ Jobs.JobID) | (→ SalaryRanges.SalaryRangeID) | (→ JobSkills.JobSkillID) | |
| 1 | 1 | 1 | 1 |
| 2 | 2 | 2 | 2 |
| 3 | 3 | 3 | 3 |
| 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 |