## Companies

id | name
--- | ---
1 | Events Unlimited
2 | Party Planners Inc.

## JobRoles

id | roleName
--- | ---
1 | Event_Planner
2 | Wedding_Coordinator
3 | Marketing Manager
4 | Accountant

## EventPlannerJobPosting

id | companyId | jobRoleId | postedDate
--- | --- | --- | ---
| (→ Companies.id) | (→ JobRoles.id) |
1 | 1 | 1 | 2023-01-01
2 | 2 | 2 | 2023-01-16

## WeddingCoordinatorJobPosting

id | companyId | jobRoleId | postedDate
--- | --- | --- | ---
| (→ Companies.id) | (→ JobRoles.id) |
1 | 1 | 3 | 2023-02-07
2 | 2 | 4 | 2023-02-28

## SalaryRange

id | minSalary | maxSalary
--- | --- | ---
| (→ EventPlannerJobPosting.postedDate) | (→ WeddingCoordinatorJobPosting.postedDate)
1 | 35000 | 45000
2 | 40000 | 50000
3 | 50000 | 60000
4 | 55000 | 65000
5 | 60000 | 70000

## SkillsRequired

id | skillName
--- | ---
| (→ EventPlannerJobPosting.roleName)
1 | Project Management
2 | Budgeting
3 | Venue Coordination
4 | Client Relations
5 | Negotiation