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 |