Hotel

idnameaddressprice
(→ PriceTable.value)
1Grand Plaza123 Main St50.0
2Ritz Carlton456 Central Ave100.0

Youth_hostel

idnameaddressprice
(→ PriceTable.value)
1Backpacker Inn789 Pine St50.0
2Budget Lodge987 Oak St75.0

Room

idhotel_idtypeoccupancyprice
(→ Hotel.id)(→ PriceTable.value)
11Deluxe Suite275.0
22Executive Suite3150.0
31Standard Double250.0
42Economy Twin275.0

Booking

idroom_idcustomer_namecheckincheckoutstatus
(→ Room.id)
11John Doe2023-01-01 10:00:002023-01-03 10:00:00Confirmed
22Jane Smith2023-01-05 10:00:002023-01-07 10:00:00Confirmed

PriceTable

value
50.0
75.0
100.0
150.0
200.0