## Company

id | name
--- | ---
1 | Events Unlimited
2 | Grand Celebrations

## Event_Planner

id | companyId | experience | skills
--- | --- | --- | ---
| (→ Company.id) |  |
1 | 1 | 3 | Organization, Communication
2 | 2 | 6 | Decorating, Coordination

## Wedding_Coordinator

id | companyId | experience | skills
--- | --- | --- | ---
| (→ Company.id) |  |
1 | 1 | 2 | Designing, Planning
2 | 2 | 7 | Vendor Relationships, Budgeting

## Employee

id | firstName | lastName | email
--- | --- | --- | ---
1 | John | Smith | johnsmith@gmail.com
2 | Jane | Doe | janedoe@gmail.com
3 | Alice | Brown | alicebrown@gmail.com
4 | Mike | White | mwhite@gmail.com
5 | Emily | Black | eblack@gmail.com

## Salary

id | employeeId | salary | startDate | endDate
--- | --- | --- | --- | ---
| (→ Employee.id) |  |  |
1 | 1 | 80000 | 2021-01-01 | 2023-12-31
2 | 2 | 90000 | 2019-01-01 | 2022-12-31
3 | 3 | 85000 | 2020-01-01 | Present
4 | 4 | 82000 | 2018-01-01 | 2021-12-31
5 | 5 | 88000 | 2021-01-01 | Present

## Benefits

id | employeeId | healthInsurance | retirementPlan | vacationDays
--- | --- | --- | --- | ---
| (→ Employee.id) |  |  |
1 | 1 | 1 | 1 | 15
2 | 2 | 1 | 1 | 20
3 | 3 | 1 | 0 | 25
4 | 4 | 0 | 1 | 30
5 | 5 | 1 | 1 | 22