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 |