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. |