## Clients

ClientID | FirstName | LastName | Email | PhoneNumber
--- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | 5556667788
2 | Jane | Smith | jane.smith@example.com | 5559993322

## Rooms

RoomID | Name | Type | Floor
--- | --- | --- | ---
1 | Ballroom | Ballroom | 1
2 | Boardroom | Meeting Room | 2

## Events

EventID | Date | Time | ClientID
--- | --- | --- | ---
|  |  | (→ Clients.ClientID)
1 | 2022-01-01 | 10:00:00 | 1
2 | 2022-01-02 | 14:00:00 | 2

## RoomReservations

ReservationID | RoomID | EventID
--- | --- | ---
| (→ Rooms.RoomID) | (→ Events.EventID)
1 | 1 | 1
2 | 2 | 2

## Capacities

CapacityID | Capacity
--- | ---
1 | 200
2 | 150

## EventSpaces

EventSpaceID | EventSpaceName | RoomID | CapacityID
--- | --- | --- | ---
|  | (→ Rooms.RoomID) | (→ Capacities.CapacityID)
1 | Banquet Hall | 1 | 1
2 | Banquet Hall | 1 | 2
3 | Conference Room | 2 | 1
4 | Conference Room | 2 | 2