## Hotels

HotelID | Name | Address | City
--- | --- | --- | ---
1 | Grand Plaza | 123 Main St | New York
2 | Luxury Suites | 456 Broadway | Los Angeles
3 | Cozy Inn | 789 Park Ave | Chicago

## Rooms

RoomID | HotelID | RoomType | NumberOfSeats
--- | --- | --- | ---
| (→ Hotels.HotelID) |  |
1 | 1 | Deluxe Suite | 4
2 | 1 | Standard Room | 2
3 | 2 | Premium Suite | 5
4 | 2 | Economy Room | 2
5 | 3 | Family Suite | 6

## Patios

PatioID | RoomID | AreaSize
--- | --- | ---
| (→ Rooms.RoomID) |
1 | 1 | 100 sqm
2 | 2 | 200 sqm
3 | 3 | 150 sqm

## Verandas

VerandaID | RoomID | Length | Width
--- | --- | --- | ---
| (→ Rooms.RoomID) |  |
1 | 1 | 20 m | 10 m
2 | 2 | 30 m | 10 m
3 | 3 | 25 m | 10 m

## Reservations

ReservationID | GuestID | CheckInDate | CheckOutDate | RoomID
--- | --- | --- | --- | ---
| (→ Guests.GuestID) |  |  | (→ Rooms.RoomID)
1 | 1 | 2021-07-01 | 2021-07-05 | 1
2 | 2 | 2021-07-10 | 2021-07-14 | 2
3 | 3 | 2021-07-15 | 2021-07-19 | 3

## 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 | +1112223334
4 | Mike | Green | mike.green@example.com | +4445556667
5 | Emma | White | emma.white@example.com | +7778889990