| id | Name | Age |
|---|---|---|
| 1 | Alice | 30 |
| 2 | Bob | 28 |
| id | Name | Description | Location |
|---|---|---|---|
| (→ Locations.Name) | |||
| 1 | Museum of Natural History | A museum showcasing natural history. | Portobello |
| 2 | Art Gallery | An art gallery featuring local artists. | Notting Hill |
| id | Name | Type | Location |
|---|---|---|---|
| (→ Locations.Name) | |||
| 1 | Farmers Market | Organic produce and handmade crafts. | Portobello |
| 2 | Shopping Centre | Clothing stores and electronics shops. | Kensington |
| Name | Longitude | Latitude |
|---|---|---|
| Portobello | -0.1967 | 51.5164 |
| Notting Hill | -0.1897 | 51.5172 |
| Kensington | -0.1842 | 51.5149 |
| id | touristId | attractionId | marketId | VisitDate |
|---|---|---|---|---|
| (→ Tourists.id) | (→ Attractions.id) | (→ Markets.id) | ||
| 1 | 1 | 1 | None | 2022-01-01 |
| 2 | None | 2 | 2 | 2022-01-02 |
| id | visitorId | attractionId | reviewText | rating |
|---|---|---|---|---|
| (→ Tourists.id) | (→ Attractions.id) | |||
| 1 | 1 | 1 | Great experience! Loved it. | 5 |
| 2 | None | 2 | Could have been better. | 3 |