Companies

idnameaddressphoneNumber
1Events Unlimited123 Main St555-0000
2Celebrations Inc.456 Elm St555-1111
3Party Planning Plus789 Oak St555-2222
4Festive Solutions101 Pine St555-3333
5Weddings by Design202 Cedar St555-4444

Events

eventIdcompanyIdindustrydatelocation
(→ Companies.id)
11Event Planner2023-01-15 12:00:00Downtown Hall
22Event Planner2023-02-10 18:00:00City Center Ballroom
31Wedding Coordinator2023-03-25 16:00:00Garden Wedding Venue
42Wedding Coordinator2023-04-08 14:00:00Beachside Resort
53Conference Organizer2023-05-01 09:00:00Convention Center

Employees

employeeIdfirstNamelastNamepositionhireDate
1JohnSmithEvent Manager2022-01-15
2JaneDoeAssistant Event Planner2022-02-10
3MichaelBrownEvent Coordinator2022-03-25
4AliceGreenWedding Specialist2022-04-08
5DavidBlackGraphic Designer2022-05-01

EventEmployee

eventIdemployeeIdrole
(→ Events.eventId)(→ Employees.employeeId)
11Team Lead
12Decorator
23Stage Manager
34Floral Arranger
45Photographer