Convention_Centers

idnamecapacity
1Center A1000
2Center B2000
3Center C3000
4Center D4000
5Center E5000

Event_Spaces

idspace_nametype
1Duty-Free Shoppingshop
2Exhibition Hallhall
3Banquet Roomroom
4Theatertheatre
5Lounge Arealounge

Rooms

idroom_numberfloor_nocapacity
1101150
2102160
3103170
4201280
5202290
62032100
73013110
83023120
93033130

Guests

idfirst_namelast_nameemail
1JohnSmithjohnsmith@example.com
2JaneDoejanedoe@example.com
3MichaelBlackmblack@example.com
4EmilyWhiteemwhite@example.com
5DavidGraydgray@example.com

Reservations

idguest_idevent_space_idcheckincheckout
(→ Guests.id)(→ Event_Spaces.id)
1112021-05-01 10:00:002021-05-01 18:00:00
2222021-05-02 10:00:002021-05-02 18:00:00
3332021-05-03 10:00:002021-05-03 18:00:00
4442021-05-04 10:00:002021-05-04 18:00:00
5552021-05-05 10:00:002021-05-05 18:00:00

Convention_Centers_Event_Spaces

convention_center_idevent_space_id
(→ Convention_Centers.id)(→ Event_Spaces.id)
11
12
21
22
31
32
41
42
51
52