hotels
| id | name | location | accommodation_type |
| 1 | Grand Hotel | Downtown | Hotel |
| 2 | Park Plaza | Uptown | Hotel |
| 3 | Young Travelers Hostel | City Center | Youth Hostel |
| 4 | Backpacker Inn | Suburbia | Youth Hostel |
| 5 | Luxury Suites | Beachside | Hotel |
| 6 | Mountain Retreat | Outskirts | Hotel |
yhostels
| id | name | location | accommodation_type |
| 1 | Global Nomads | Airport Area | Youth Hostel |
| 2 | Student Haven | University District | Youth Hostel |
| 3 | Adventure Lodge | Nature Reserve | Youth Hostel |
| 4 | Surf & Turf Hostel | Seaside | Youth Hostel |
| 5 | Art Lovers Hangout | Arts Quarter | Youth Hostel |
rooms
| hotel_id | room_number | price |
| (→ hotels.id) | | |
| 1 | 101 | 50.0 |
| 3 | 301 | 50.0 |
| 4 | 401 | 80.0 |
| 6 | 601 | 50.0 |
reviews
| user_name | review_text | rating | room_number |
| | | (→ rooms.room_number) |
| John Doe | Great experience! | 5 | 101 |
| Jane Smith | Not what I expected. | 3 | 201 |
| Emma Brown | Fantastic stay! | 5 | 301 |
| Mike Johnson | Too expensive. | 2 | 401 |
| Laura Wilson | Awesome hostel! | 4 | 501 |
| William Clark | I will come back again! | 5 | 601 |
| Kate King | Not my cup of tea. | 3 | 701 |