| id | name |
|---|---|
| 1 | Events Unlimited |
| 2 | Grand Celebrations |
| id | companyId | experience | skills |
|---|---|---|---|
| (→ Company.id) | |||
| 1 | 1 | 3 | Organization, Communication |
| 2 | 2 | 6 | Decorating, Coordination |
| id | companyId | experience | skills |
|---|---|---|---|
| (→ Company.id) | |||
| 1 | 1 | 2 | Designing, Planning |
| 2 | 2 | 7 | Vendor Relationships, Budgeting |
| id | firstName | lastName | |
|---|---|---|---|
| 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 |
| 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 |
| 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 |