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 |