Magicians

idNameAgeStreet_Location
(→ Locations.Name)
1Harry Houdini130Times Square, New York
2David Copperfield65Bryant Park, New York
3Criss Angel47Central Park, New York
4Dynamo39Times Square, New York
5Penn & Teller75Bryant Park, New York

Mimes

idNameAgeStreet_Location
(→ Locations.Name)
1Marcel Marceau88Times Square, New York
2Whitey McConnell95Bryant Park, New York
3Charlie Chaplin130Central Park, New York
4Eric Jan De Groot70Times Square, New York
5Leonard Pitts Jr.68Bryant Park, New York

Locations

idLocationName
1Times Square, New York
2Bryant Park, New York
3Central Park, New York

Shows

idShowTitleStartTimeEndTimeLocationIDMagicianIDMimeID
(→ Locations.id)(→ Magicians.id)(→ Mimes.id)
1The Magic of Harry Houdini2022-11-01 19:00:002022-11-01 21:00:0011None
2A Night of Illusion2022-11-02 19:00:002022-11-02 21:00:0022None
3The Art of Silence2022-11-03 19:00:002022-11-03 21:00:00334
4The World of Marvel2022-11-04 19:00:002022-11-04 21:00:004None5
5Laughter and Wonder2022-11-05 19:00:002022-11-05 21:00:00546

Tickets

idPurchaserNameShowIDSeatNumberPrice
(→ Shows.id)
1John Doe1125
2Jane Smith1225
3Alice Johnson2130
4Bob Brown2230
5Emma Wilson3135

Reviews

idReviewerNameRatingCommentShowID
(→ Shows.id)
1John Doe5Great show! Loved it!1
2Jane Smith4Enjoyed the magic tricks!1
3Alice Johnson3Good performance but could have been better.2
4Bob Brown2Not my cup of tea.2
5Emma Wilson4Amazing mime performance!3