| 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 |
| GuestID | FirstName | LastName | |
|---|---|---|---|
| 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 |
| 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 |
| AccommodationID | RoomNumber | TypeOfAccomodation | PricePerNight | NumberGuests | HotelID |
|---|---|---|---|---|---|
| (→ Hotels.HotelID) | |||||
| 1 | 101 | Family Suite | 150.0 | 4 | 1 |
| 2 | 102 | Family Suite | 200.0 | 4 | 1 |
| 3 | 201 | Single Room | 150.0 | 1 | 2 |
| 4 | 202 | Single Room | 200.0 | 1 | 2 |
| 5 | 301 | Deluxe Double | 250.0 | 2 | 3 |
| 6 | 401 | Standard King | 100.0 | 1 | 4 |
| 7 | 501 | Junior Suite | 300.0 | 3 | 5 |