| id | companyName |
|---|---|
| 1 | Company A |
| 2 | Company B |
| 3 | Company C |
| 4 | Company D |
| 5 | Company E |
| id | locationName |
|---|---|
| 1 | Location 1 |
| 2 | Location 2 |
| 3 | Location 3 |
| 4 | Location 4 |
| 5 | Location 5 |
| id | title |
|---|---|
| 1 | Software Developer |
| 2 | Data Scientist |
| 3 | Product Manager |
| 4 | UX Designer |
| 5 | QA Engineer |
| jobId | managementRole | projectDurationEstimate | salaryRange | companyID | locationID | jobTitleID |
|---|---|---|---|---|---|---|
| (→ Companies.id) | (→ Locations.id) | (→ JobTitles.id) | ||||
| 1 | Project Manager | 4 weeks | 60k - 80k | 1 | 1 | 1 |
| 2 | Project Manager | 8 weeks | 70k - 90k | 2 | 2 | 1 |
| 3 | Business Analyst | 4 weeks | 50k - 70k | 3 | 3 | 2 |
| 4 | Business Analyst | 6 weeks | 60k - 80k | 4 | 4 | 2 |
| 5 | Development Lead | 2 months | 90k - 110k | 1 | 1 | 3 |
| 6 | Design Team Leader | 3 months | 80k - 100k | 2 | 2 | 4 |
| 7 | Product Owner | 2 years | 100k - 120k | 3 | 3 | 1 |
| 8 | UI/UX Architect | 1 year | 80k - 100k | 4 | 4 | 5 |
| 9 | Quality Assurance Specialist | 1 month | 40k - 60k | 5 | 5 | 6 |