## Magicians

id | Name | Street_Location | MagicType | YearsExperience
--- | --- | --- | --- | ---
1 | Harry Houdini | Times Square, New York | Escape Artist | 10
2 | David Copperfield | Las Vegas | Illusionist | 38

## Mimes

id | Name | Street_Location | StyleOfMiming | PerformanceDuration
--- | --- | --- | --- | ---
1 | Marcel Marceau | Times Square, New York | Classic | 20
2 | Whitey McConnell | Boston | Character Miming | 15

## Shows

id | ShowName | StartTime | EndTime | LocationID
--- | --- | --- | --- | ---
|  |  |  | (→ Venues.id)
1 | The Illusionists | 2022-07-15 19:00:00 | 2022-07-15 21:00:00 | 1
2 | Cirque du Soleil | 2022-07-16 19:00:00 | 2022-07-16 21:00:00 | 2

## Venues

id | VenueName | Address | City | Capacity
--- | --- | --- | --- | ---
1 | Madison Square Garden | New York, NY | New York | 20000
2 | Radio City Music Hall | New York, NY | New York | 6000

## Performers

id | FirstName | LastName | Age | Genre
--- | --- | --- | --- | ---
1 | Christopher | Columbus | 35 | Juggling
2 | Carlos | Leon | 28 | Fire Eating