## Hotels

HotelID | Name | Address | City | Country
--- | --- | --- | --- | ---
1 | Grand Central | 34 Vanderbilt Ave | New York | USA
2 | Hilton Garden Inn | 7982 West Sunrise Blvd. | Plantation | USA
3 | The Ritz Carlton | 160 E 53rd St | New York | USA
4 | Radisson Blu Mall of America | 2100 Killebrew Drive | Bloomington | USA
5 | Holiday Inn Express | 2804 S College Blvd | Fort Collins | USA

## Accommodations

AccommodationID | TypeOfAccomodation | PricePerNight | NumberGuests | HotelID
--- | --- | --- | --- | ---
|  |  |  | (→ Hotels.HotelID)
1 | Family Suite | 150.0 | 4 | 1
2 | Family Suite | 200.0 | 4 | 1
3 | Single Room | 150.0 | 1 | 2
4 | Single Room | 200.0 | 1 | 2
5 | Deluxe Double | 250.0 | 2 | 3
6 | Standard King | 100.0 | 1 | 4
7 | Junior Suite | 300.0 | 3 | 5

## Guests

GuestID | FirstName | LastName | Email
--- | --- | --- | ---
1 | John | Doe | john@example.com
2 | Jane | Smith | jane@example.com
3 | Michael | Brown | michael@example.com
4 | Emma | Wilson | emma@example.com
5 | Alice | Jackson | alice@example.com

## Bookings

BookingID | CheckInDate | CheckOutDate | AccommodationID | GuestID | TotalCost
--- | --- | --- | --- | --- | ---
|  |  | (→ Accommodations.AccommodationID) | (→ Guests.GuestID) |
1 | 2022-08-01 | 2022-08-05 | 1 | 1 | 750.0
2 | 2022-08-10 | 2022-08-14 | 2 | 2 | 1000.0
3 | 2022-08-15 | 2022-08-20 | 3 | 3 | 1500.0
4 | 2022-08-21 | 2022-08-25 | 4 | 4 | 300.0
5 | 2022-08-26 | 2022-08-30 | 5 | 5 | 1200.0