## Customers

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

## Hotels

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

## Rooms

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

## Reservations

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

## Reviews

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