## FunctionRooms

ID | Name | Description
--- | --- | ---
1 | Ballroom | A large room suitable for weddings and conferences.
2 | Green Room | A cozy room perfect for small gatherings.

## SeatingCapacities

CapacityID | MaxOccupancy
--- | ---
1 | 200
2 | 150

## Bookings

BookingId | ClientName | ContactInfo | DateOfBooking | StartTime | EndTime | FunctionRoomID | SeatingCapacityID
--- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ FunctionRooms.ID) | (→ SeatingCapacities.CapacityID)
1 | John Doe | +123456789 | 2023-01-01 10:00:00 | 14:00 | 16:00 | 1 | 1
2 | Jane Smith | +098765432 | 2023-01-02 10:00:00 | 14:00 | 16:00 | 1 | 2
3 | Alice Johnson | +123456789 | 2023-01-03 10:00:00 | 14:00 | 16:00 | 2 | 1
4 | Bob Brown | +098765432 | 2023-01-04 10:00:00 | 14:00 | 16:00 | 2 | 2

## Employees

EmployeeId | FirstName | LastName | Role | Salary | HireDate
--- | --- | --- | --- | --- | ---
1 | Emma | Wilson | Event Coordinator | 45000.0 | 2022-01-01
2 | Michael | Davis | Chef | 50000.0 | 2022-01-01
3 | Anna | Taylor | Housekeeping Supervisor | 35000.0 | 2022-01-01

## Clients

ClientId | FirstName | LastName | Email | PhoneNumber | Address
--- | --- | --- | --- | --- | ---
1 | Tom | Hanks | tom@example.com | +123456789 | 123 Main St
2 | Chris | Evans | chris@example.com | +987654321 | 456 Elm St
3 | Linda | Cardellini | linda@example.com | +135792468 | 789 Oak St
4 | Elijah | Wood | elijah@example.com | +246813579 | 123 Pine St