Company

idname
1Events Unlimited
2Grand Celebrations

Event_Planner

idcompanyIdexperienceskills
(→ Company.id)
113Organization, Communication
226Decorating, Coordination

Wedding_Coordinator

idcompanyIdexperienceskills
(→ Company.id)
112Designing, Planning
227Vendor Relationships, Budgeting

Employee

idfirstNamelastNameemail
1JohnSmithjohnsmith@gmail.com
2JaneDoejanedoe@gmail.com
3AliceBrownalicebrown@gmail.com
4MikeWhitemwhite@gmail.com
5EmilyBlackeblack@gmail.com

Salary

idemployeeIdsalarystartDateendDate
(→ Employee.id)
11800002021-01-012023-12-31
22900002019-01-012022-12-31
33850002020-01-01Present
44820002018-01-012021-12-31
55880002021-01-01Present

Benefits

idemployeeIdhealthInsuranceretirementPlanvacationDays
(→ Employee.id)
111115
221120
331025
440130
551122