## Rooms

RoomID | Building | Area | Spa | Occupied | Rate
--- | --- | --- | --- | --- | ---
1 | Building A | Area 101 | 1 | 0 | 299.99
2 | Building B | Area 201 | 0 | 1 | 399.99
3 | Building C | Area 301 | 1 | 1 | 499.99
4 | Building D | Area 401 | 0 | 0 | 599.99
5 | Building E | Area 501 | 1 | 0 | 699.99

## Customers

CustomerID | FirstName | LastName | Email | PhoneNumber
--- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | +123456789
2 | Jane | Smith | jane.smith@example.com | +987654321
3 | Michael | Brown | michael.brown@example.com | +111222333
4 | Emily | White | emily.white@example.com | +444555666
5 | David | Black | david.black@example.com | +777888999

## Reservations

ReservationID | CustomerID | CheckInDate | CheckOutDate | TotalAmount
--- | --- | --- | --- | ---
| (→ Customers.CustomerID) |  |  |
1 | 1 | 2023-01-01 | 2023-01-05 | 1000.0
2 | 2 | 2023-01-10 | 2023-01-15 | 1200.0
3 | 3 | 2023-01-20 | 2023-01-25 | 1400.0
4 | 4 | 2023-02-01 | 2023-02-05 | 1600.0
5 | 5 | 2023-02-10 | 2023-02-15 | 1800.0

## Services

ServiceID | Description | Price
--- | --- | ---
1 | Room upgrade to suite | 150.0
2 | Extra bed | 50.0
3 | Late checkout | 100.0
4 | Breakfast buffet | 30.0
5 | Welcome drink at bar | 15.0

## BookedServices

BookingID | ReservationID | ServiceID | Quantity | TotalAmount
--- | --- | --- | --- | ---
| (→ Reservations.ReservationID) | (→ Services.ServiceID) |  |
1 | 1 | 1 | 1 | 150.0
2 | 1 | 2 | 1 | 50.0
3 | 1 | 3 | 1 | 100.0
4 | 1 | 4 | 1 | 30.0
5 | 1 | 5 | 1 | 15.0