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 |