| 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 |
| CustomerID | FirstName | LastName | 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 |
| 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 |
| 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 |
| 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 |