| hotel_id | name | location |
|---|---|---|
| 1 | Grand Art Hotel | Downtown |
| 2 | Eco Lodge | Suburbs |
| 3 | Crystal Palace | Beachside |
| 4 | Mountain Retreat | Uptown |
| 5 | River View Inn | City Center |
| theme_id | theme_name |
|---|---|
| 1 | Art_themed |
| 2 | Historical_themed |
| 3 | Nature_themed |
| 4 | Modern_themed |
| 5 | Romantic_themed |
| boutique_hotel_id | theme_id |
|---|---|
| (→ Boutique_Hotels.hotel_id) | (→ Themes.theme_id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 4 |