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

Magicians

idNameAgeStreet_Location
(→ Locations.id)
1Harry Houdini1301
2David Copperfield652
3Criss Angel473
4Dynamo391
5Penn & Teller752

Mimes

idNameAgeStreet_Location
(→ Locations.id)
1Marcel Marceau881
2Whitey McConnell952
3Charlie Chaplin1303
4Eric Jan De Groot701
5Leonard Pitts Jr.682