## Hotels

HotelID | Opening_Year | Opening_Month | Name | Address | City | Country
--- | --- | --- | --- | --- | --- | ---
1 | 2000 | 1 | Grand Plaza | 123 Main St | New York | USA
2 | 2018 | 6 | The Ritz | 456 Broadway | London | UK
3 | 2005 | 9 | Ocean View | 789 Beach Ave | Miami | USA

## Rooms

RoomID | HotelID | Type | Capacity | Rate
--- | --- | --- | --- | ---
| (→ Hotels.HotelID) |  |  |
1 | 1 | Standard | 4 | 150.0
2 | 1 | Deluxe | 2 | 200.0
3 | 2 | Luxury | 1 | 300.0
4 | 2 | Suite | 2 | 400.0
5 | 3 | Sea View | 4 | 180.0

## Bookings

BookingID | GuestID | RoomID | CheckInDate | CheckOutDate | TotalCost
--- | --- | --- | --- | --- | ---
| (→ Guests.GuestID) | (→ Rooms.RoomID) |  |  |
1 | 1 | 1 | 2022-01-01 | 2022-01-05 | 600.0
2 | 2 | 2 | 2022-01-10 | 2022-01-14 | 800.0
3 | 3 | 3 | 2022-02-01 | 2022-02-05 | 720.0
4 | 4 | 4 | 2022-03-01 | 2022-03-05 | 960.0
5 | 5 | 5 | 2022-04-01 | 2022-04-05 | 840.0

## Guests

GuestID | FirstName | LastName | Email | PhoneNumber
--- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | +1234567890
2 | Jane | Smith | jane.smith@example.com | +0987654321
3 | Alice | Brown | alice.brown@example.com | +1122334455
4 | Bob | White | bob.white@example.com | +2233445566
5 | Charlie | Black | charlie.black@example.com | +3344556677

## StaffMembers

StaffMemberID | FullName | Position | Department | HireDate
--- | --- | --- | --- | ---
1 | Emma Jones | Receptionist | Front Desk | 2021-05-15
2 | Tom Smith | Housekeeping Supervisor | Housekeeping | 2021-06-01
3 | Ann Brown | Food and Beverage Manager | Restaurant | 2021-07-15
4 | Jack White | Maintenance Supervisor | Engineering | 2021-08-01
5 | Peter Black | Concierge | General Services | 2021-09-01

## Services

ServiceID | Description | Cost | Available
--- | --- | --- | ---
1 | Laundry service | 5.0 | 1
2 | Room cleaning | 10.0 | 1
3 | Shuttle to airport | 50.0 | 1
4 | Breakfast buffet | 20.0 | 1
5 | Gym access | 25.0 | 1