Accommodations

IDNameType_of_AccommodationPrice
1Grand HotelHotel50.0
2Cozy InnHotel80.0
3Backpacker LodgeYouth Hostel50.0
4World Explorer HostelYouth Hostel60.0
5Paradise ResortResort120.0
6Luxury SuitesApartment130.0

Customers

CustomerIDFirstNameLastNameEmail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3AliceWonderlandalice.wonderland@example.com
4BobBuilderbob.builder@example.com

Booking

BookingIDCustomerIDAccommodationIDCheckInDateCheckOutDate
(→ Customers.CustomerID)(→ Accommodations.ID)
1112022-07-102022-07-17
2222022-08-052022-08-12
3332022-09-012022-09-08
4442022-10-152022-10-22

Reviews

ReviewIDAccommodationIDRatingComment
(→ Accommodations.ID)
114Great location but noisy.
225Very comfortable and clean.
333Nice place with friendly staff.
442Not what I expected.