Street_Performers

idPerformer_NamePerformance_Type
(→ Types.Type_ID)
1John DoeMagician
2Jane SmithMime
3Emma JohnsonClown
4David BrownAcrobat
5Sophia WilsonFire Breather

Types

Type_IDType_Description
1Close Up Magic
2Stage Magic
3Puppetry
4Dance
5Musical Performance
6Illusionist
7Comedic Mime
8Balloon Artist
9Aerialist
10Contortionist

Locations

Location_IDStreet_AddressCityCountry
17 Times SqNew YorkUSA
250 Broadway StLos AngelesUSA
33 Champs ElyseesParisFrance
46 Hyde ParkLondonUK
58 Red SquareMoscowRussia

Event_Schedule

Schedule_IDDateTimePerformer_IDLocation_ID
(→ Street_Performers.id)(→ Locations.Location_ID)
12022-09-0112:00 PM11
22022-09-0103:00 PM21
32022-09-0206:00 PM12
42022-09-0309:00 AM26
52022-09-0412:00 PM13