| ID | Name | Description |
|---|---|---|
| 1 | Ballroom | A large room suitable for weddings and conferences. |
| 2 | Green Room | A cozy room perfect for small gatherings. |
| CapacityID | MaxOccupancy |
|---|---|
| 1 | 200 |
| 2 | 150 |
| 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 |
| 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 |
| ClientId | FirstName | LastName | 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 |