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

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

Accommodations

AccommodationIDRoomNumberTypeOfAccomodationPricePerNightNumberGuestsHotelID
(→ Hotels.HotelID)
1101Family Suite150.041
2102Family Suite200.041
3201Single Room150.012
4202Single Room200.012
5301Deluxe Double250.023
6401Standard King100.014
7501Junior Suite300.035