## Guests

id | firstName | lastName | emailAddress
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com
3 | Alice | Brown | alice.brown@example.com
4 | Bob | Green | bob.green@example.com
5 | Charlie | Black | charlie.black@example.com

## Reservations

reservationId | guestID | checkInDate | checkOutDate | overnightStays | amenities
--- | --- | --- | --- | --- | ---
| (→ Guests.id) |  |  |  |
1 | 1 | 2023-01-01 | 2023-01-03 | Guestroom | Air Conditioning
2 | 2 | 2023-01-06 | 2023-01-08 | Guestroom | No Air Conditioning
3 | 3 | 2023-01-10 | 2023-01-12 | Suite | Air Conditioning
4 | 4 | 2023-01-13 | 2023-01-15 | Suite | No Air Conditioning
5 | 5 | 2023-01-17 | 2023-01-19 | Guestroom | No Air Conditioning

## Rooms

roomNumber | typeOfRoom | pricePerNight
--- | --- | ---
1 | Standard Room | 100
2 | Deluxe Suite | 200
3 | Premium Suite | 300
4 | Family Suite | 250
5 | Executive Suite | 400

## Bookings

bookingId | reservationId | roomNumber
--- | --- | ---
| (→ Reservations.reservationId) | (→ Rooms.roomNumber)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5

## Reviews

reviewId | bookingId | rating | comments
--- | --- | --- | ---
| (→ Bookings.bookingId) |  |
1 | 1 | 5 | Great stay! Very clean.
2 | 2 | 4 | The suite was nice but a bit expensive.
3 | 3 | 5 | Loved it! Perfect location.
4 | 4 | 4 | Good experience overall.
5 | 5 | 3 | Not what I expected.