Capacity
ID | CapacityValue |
1 | 180 |
2 | 300 |
3 | 250 |
4 | 400 |
5 | 200 |
Banquethalls
ID | HallName | CapacityID |
| | (→ Capacity.ID) |
1 | Banquet_Hall | 1 |
2 | Grand Ballroom | 2 |
3 | Rooftop Garden | 3 |
4 | Courtyard | 4 |
5 | Terrace | 5 |
Conferencerooms
ID | RoomName | CapacityID |
| | (→ Capacity.ID) |
1 | Boardroom A | 1 |
2 | Meeting Room B | 2 |
3 | Seminar C | 3 |
4 | Workshop D | 4 |
5 | Auditorium E | 5 |
Bookings
ID | ClientName | DateOfBooking | TimeOfBooking | BanquethallID | ConferenceRoomID |
| | | | (→ Banquethalls.ID) | (→ Conferencerooms.ID) |
1 | John Doe | 2022-06-01 | 17:00 | 1 | None |
2 | Jane Smith | 2022-06-02 | 19:00 | 2 | None |
3 | Alice Brown | 2022-06-03 | 10:00 | 3 | None |
4 | Mike Johnson | 2022-06-04 | 15:00 | 4 | None |
5 | Emma Wilson | 2022-06-05 | 11:00 | 5 | None |
6 | David Lee | 2022-06-01 | 17:00 | 1 | 1 |
7 | Samantha Taylor | 2022-06-02 | 19:00 | 2 | 2 |
8 | Chris Evans | 2022-06-03 | 10:00 | 3 | 3 |
9 | Kevin Hart | 2022-06-04 | 15:00 | 4 | 4 |
10 | Dwayne Johnson | 2022-06-05 | 11:00 | 5 | 5 |