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 |