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 |