Magicians

idNameStreet_LocationMagicTypeYearsExperience
1Harry HoudiniTimes Square, New YorkEscape Artist10
2David CopperfieldLas VegasIllusionist38

Mimes

idNameStreet_LocationStyleOfMimingPerformanceDuration
1Marcel MarceauTimes Square, New YorkClassic20
2Whitey McConnellBostonCharacter Miming15

Shows

idShowNameStartTimeEndTimeLocationID
(→ Venues.id)
1The Illusionists2022-07-15 19:00:002022-07-15 21:00:001
2Cirque du Soleil2022-07-16 19:00:002022-07-16 21:00:002

Venues

idVenueNameAddressCityCapacity
1Madison Square GardenNew York, NYNew York20000
2Radio City Music HallNew York, NYNew York6000

Performers

idFirstNameLastNameAgeGenre
1ChristopherColumbus35Juggling
2CarlosLeon28Fire Eating