Tourists

IDNameActivityLocation
1John DoeTourist AttractionPortobello
2Jane SmithTourist AttractionSomewhere Else
3Alice JohnsonLocal MarketPortobello
4Bob BrownLocal MarketSomewhere Else
5Charlie DavisTourist AttractionAnother Place

Markets

IDNameActivityLocation
1Central Food MarketLocal MarketPortobello
2Downtown GroceriesLocal MarketSomewhere Else
3Harbor BazaarLocal MarketAnother Place
4Uptown FareLocal MarketYet Another Place
5Riverfront PantryLocal MarketA Different Place

Activities

IDActivityName
1The Eiffel Tower
2Colosseum
3Statue of Liberty
4Great Wall of China
5Christ the Redeemer

Locations

IDLocationName
1Paris
2Rome
3New York City
4Beijing
5Rio de Janeiro

Visitors

IDNameDateOfVisit
1Michael Thompson2023-01-01 10:00:00
2Emily Watson2023-01-02 12:00:00
3David Jackson2023-01-03 14:00:00
4Sophia King2023-01-04 16:00:00
5Liam Scott2023-01-05 18:00:00

VisitRecords

IDVisitorIDTouristAttractionIDLocalMarketID
(→ Visitors.ID)(→ Tourists.ID)(→ Markets.ID)
1111
2122
3233
4244
5355