Hotels

HotelIDNameAddressCityCountry
1Grand Central34 Vanderbilt AveNew YorkUSA
2Hilton Garden Inn7982 West Sunrise Blvd.PlantationUSA
3The Ritz Carlton160 E 53rd StNew YorkUSA
4Radisson Blu Mall of America2100 Killebrew DriveBloomingtonUSA
5Holiday Inn Express2804 S College BlvdFort CollinsUSA

Accommodations

AccommodationIDTypeOfAccomodationPricePerNightNumberGuestsHotelID
(→ Hotels.HotelID)
1Family Suite150.041
2Family Suite200.041
3Single Room150.012
4Single Room200.012
5Deluxe Double250.023
6Standard King100.014
7Junior Suite300.035

Guests

GuestIDFirstNameLastNameEmail
1JohnDoejohn@example.com
2JaneSmithjane@example.com
3MichaelBrownmichael@example.com
4EmmaWilsonemma@example.com
5AliceJacksonalice@example.com

Bookings

BookingIDCheckInDateCheckOutDateAccommodationIDGuestIDTotalCost
(→ Accommodations.AccommodationID)(→ Guests.GuestID)
12022-08-012022-08-0511750.0
22022-08-102022-08-14221000.0
32022-08-152022-08-20331500.0
42022-08-212022-08-2544300.0
52022-08-262022-08-30551200.0