Clients

ClientIDFirstNameLastNameEmailPhoneNumber
1JohnDoejohn.doe@example.com5556667788
2JaneSmithjane.smith@example.com5559993322

Rooms

RoomIDNameTypeFloor
1BallroomBallroom1
2BoardroomMeeting Room2

Events

EventIDDateTimeClientID
(→ Clients.ClientID)
12022-01-0110:00:001
22022-01-0214:00:002

RoomReservations

ReservationIDRoomIDEventID
(→ Rooms.RoomID)(→ Events.EventID)
111
222

Capacities

CapacityIDCapacity
1200
2150

EventSpaces

EventSpaceIDEventSpaceNameRoomIDCapacityID
(→ Rooms.RoomID)(→ Capacities.CapacityID)
1Banquet Hall11
2Banquet Hall12
3Conference Room21
4Conference Room22