EventTypes

IdTypeName
1Conference
2Wedding Reception
3Corporate Party
4Gala Dinner
5Cocktail Party

Venues

IdNameSeatingCapacity
1Grand Hotel800
2Plaza Inn600
3Central Conference Center1000
4Oceanview Resort700
5City Hall200

Ballrooms

IdVenueIdRoomNumber
(→ Venues.Id)
11Ballroom A
22Ballroom B
33Ballroom C
44Ballroom D
55Ballroom E

GreenRooms

IdVenueIdRoomNumber
(→ Venues.Id)
11Green Room A
22Green Room B
33Green Room C
44Green Room D
55Green Room E

Events

IdTypeIdStartDateEndDateVenueId
(→ EventTypes.Id)(→ Venues.Id)
112022-09-012022-09-021
222022-09-152022-09-162
332022-10-012022-10-023
442022-10-152022-10-164
552022-11-012022-11-025