Tourists

idNameAge
1Alice30
2Bob28

Attractions

idNameDescriptionLocation
(→ Locations.Name)
1Museum of Natural HistoryA museum showcasing natural history.Portobello
2Art GalleryAn art gallery featuring local artists.Notting Hill

Markets

idNameTypeLocation
(→ Locations.Name)
1Farmers MarketOrganic produce and handmade crafts.Portobello
2Shopping CentreClothing stores and electronics shops.Kensington

Locations

NameLongitudeLatitude
Portobello-0.196751.5164
Notting Hill-0.189751.5172
Kensington-0.184251.5149

Visits

idtouristIdattractionIdmarketIdVisitDate
(→ Tourists.id)(→ Attractions.id)(→ Markets.id)
111None2022-01-01
2None222022-01-02

Reviews

idvisitorIdattractionIdreviewTextrating
(→ Tourists.id)(→ Attractions.id)
111Great experience! Loved it.5
2None2Could have been better.3