Customers

CustomerIDFirstNameLastNameEmailAddressPhoneNumber
1JohnDoejohn.doe@example.com+123-456-7890
2JaneSmithjane.smith@example.com+098-765-4321
3AliceBrownalice.brown@example.com+112-345-6789
4MikeJohnsonmike.johnson@example.com+234-567-8901
5EmilyWhiteemily.white@example.com+356-789-0123

Hotels

HotelIDNameAddressCityStatePostalCodeCountry
1Grand Central1 Grand Central PlazaNew YorkNY10017USA
2The Ritz Carlton2 Ritz Carlton DriveLos AngelesCA90005USA
3Hilton Garden Inn3 Hilton Garden Inn BoulevardChicagoIL60601USA
4Fairmont San Francisco4 Nob Hill AveSan FranciscoCA94108USA
5Marriott Marquis Houston5 Marriott Marquis BlvdHoustonTX77002USA

Rooms

RoomIDHotelIDNumberTypeAmenities
(→ Hotels.HotelID)
11101Deluxe KingFree WiFi, Air conditioning, Flat-screen TV
21102Standard QueenFree WiFi, Air conditioning, Flat-screen TV
32201Executive SuiteFree WiFi, Air conditioning, Flat-screen TV, Kitchenette
42202Premium TwinFree WiFi, Air conditioning, Flat-screen TV
53301Family SuiteFree WiFi, Air conditioning, Flat-screen TV, Separate living area

Reservations

ReservationIDCheckInDateCheckOutDateGuestIDTotalCostPaymentMethod
(→ Customers.CustomerID)
12021-08-012021-08-051500Credit Card
22021-08-062021-08-102800PayPal
32021-08-112021-08-153600Cash
42021-08-162021-08-204700Credit Card
52021-08-212021-08-255900Debit Card

Reviews

ReviewIDCustomerIDHotelIDCustomer_ReviewsNumber_Of_StarsDate_Of_Review
(→ Customers.CustomerID)(→ Hotels.HotelID)
111Great experience! The staff was friendly and helpful.52021-08-03
222Excellent location and comfortable rooms.42021-08-05
333Nice hotel but could use some updates.32021-08-09
444Awesome service and great amenities.52021-08-12
555I enjoyed my stay at this lovely hotel.42021-08-15