CustomerID | FirstName | LastName | EmailAddress | PhoneNumber |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | +123-456-7890 |
2 | Jane | Smith | jane.smith@example.com | +098-765-4321 |
3 | Alice | Brown | alice.brown@example.com | +112-345-6789 |
4 | Mike | Johnson | mike.johnson@example.com | +234-567-8901 |
5 | Emily | White | emily.white@example.com | +356-789-0123 |
HotelID | Name | Address | City | State | PostalCode | Country |
---|---|---|---|---|---|---|
1 | Grand Central | 1 Grand Central Plaza | New York | NY | 10017 | USA |
2 | The Ritz Carlton | 2 Ritz Carlton Drive | Los Angeles | CA | 90005 | USA |
3 | Hilton Garden Inn | 3 Hilton Garden Inn Boulevard | Chicago | IL | 60601 | USA |
4 | Fairmont San Francisco | 4 Nob Hill Ave | San Francisco | CA | 94108 | USA |
5 | Marriott Marquis Houston | 5 Marriott Marquis Blvd | Houston | TX | 77002 | USA |
RoomID | HotelID | Number | Type | Amenities |
---|---|---|---|---|
(→ Hotels.HotelID) | ||||
1 | 1 | 101 | Deluxe King | Free WiFi, Air conditioning, Flat-screen TV |
2 | 1 | 102 | Standard Queen | Free WiFi, Air conditioning, Flat-screen TV |
3 | 2 | 201 | Executive Suite | Free WiFi, Air conditioning, Flat-screen TV, Kitchenette |
4 | 2 | 202 | Premium Twin | Free WiFi, Air conditioning, Flat-screen TV |
5 | 3 | 301 | Family Suite | Free WiFi, Air conditioning, Flat-screen TV, Separate living area |
ReservationID | CheckInDate | CheckOutDate | GuestID | TotalCost | PaymentMethod |
---|---|---|---|---|---|
(→ Customers.CustomerID) | |||||
1 | 2021-08-01 | 2021-08-05 | 1 | 500 | Credit Card |
2 | 2021-08-06 | 2021-08-10 | 2 | 800 | PayPal |
3 | 2021-08-11 | 2021-08-15 | 3 | 600 | Cash |
4 | 2021-08-16 | 2021-08-20 | 4 | 700 | Credit Card |
5 | 2021-08-21 | 2021-08-25 | 5 | 900 | Debit Card |
ReviewID | CustomerID | HotelID | Customer_Reviews | Number_Of_Stars | Date_Of_Review |
---|---|---|---|---|---|
(→ Customers.CustomerID) | (→ Hotels.HotelID) | ||||
1 | 1 | 1 | Great experience! The staff was friendly and helpful. | 5 | 2021-08-03 |
2 | 2 | 2 | Excellent location and comfortable rooms. | 4 | 2021-08-05 |
3 | 3 | 3 | Nice hotel but could use some updates. | 3 | 2021-08-09 |
4 | 4 | 4 | Awesome service and great amenities. | 5 | 2021-08-12 |
5 | 5 | 5 | I enjoyed my stay at this lovely hotel. | 4 | 2021-08-15 |