| ID | Name | Type_of_Accommodation | Price |
|---|---|---|---|
| 1 | Grand Hotel | Hotel | 50.0 |
| 2 | Cozy Inn | Hotel | 80.0 |
| 3 | Backpacker Lodge | Youth Hostel | 50.0 |
| 4 | World Explorer Hostel | Youth Hostel | 60.0 |
| 5 | Paradise Resort | Resort | 120.0 |
| 6 | Luxury Suites | Apartment | 130.0 |
| CustomerID | FirstName | LastName | |
|---|---|---|---|
| 1 | John | Doe | john.doe@example.com |
| 2 | Jane | Smith | jane.smith@example.com |
| 3 | Alice | Wonderland | alice.wonderland@example.com |
| 4 | Bob | Builder | bob.builder@example.com |
| BookingID | CustomerID | AccommodationID | CheckInDate | CheckOutDate |
|---|---|---|---|---|
| (→ Customers.CustomerID) | (→ Accommodations.ID) | |||
| 1 | 1 | 1 | 2022-07-10 | 2022-07-17 |
| 2 | 2 | 2 | 2022-08-05 | 2022-08-12 |
| 3 | 3 | 3 | 2022-09-01 | 2022-09-08 |
| 4 | 4 | 4 | 2022-10-15 | 2022-10-22 |
| ReviewID | AccommodationID | Rating | Comment |
|---|---|---|---|
| (→ Accommodations.ID) | |||
| 1 | 1 | 4 | Great location but noisy. |
| 2 | 2 | 5 | Very comfortable and clean. |
| 3 | 3 | 3 | Nice place with friendly staff. |
| 4 | 4 | 2 | Not what I expected. |