## Locations

id | LocationName
--- | ---
1 | Times Square, New York
2 | Bryant Park, New York
3 | Central Park, New York

## Shows

id | ShowTitle | StartTime | EndTime | LocationID | MagicianID | MimeID
--- | --- | --- | --- | --- | --- | ---
|  |  |  | (→ Locations.id) | (→ Magicians.id) | (→ Mimes.id)
1 | The Magic of Harry Houdini | 2022-11-01 19:00:00 | 2022-11-01 21:00:00 | 1 | 1 | None
2 | A Night of Illusion | 2022-11-02 19:00:00 | 2022-11-02 21:00:00 | 2 | 2 | None
3 | The Art of Silence | 2022-11-03 19:00:00 | 2022-11-03 21:00:00 | 3 | 3 | 4
4 | The World of Marvel | 2022-11-04 19:00:00 | 2022-11-04 21:00:00 | 4 | None | 5
5 | Laughter and Wonder | 2022-11-05 19:00:00 | 2022-11-05 21:00:00 | 5 | 4 | 6

## Tickets

id | PurchaserName | ShowID | SeatNumber | Price
--- | --- | --- | --- | ---
|  | (→ Shows.id) |  |
1 | John Doe | 1 | 1 | 25
2 | Jane Smith | 1 | 2 | 25
3 | Alice Johnson | 2 | 1 | 30
4 | Bob Brown | 2 | 2 | 30
5 | Emma Wilson | 3 | 1 | 35

## Reviews

id | ReviewerName | Rating | Comment | ShowID
--- | --- | --- | --- | ---
|  |  |  | (→ Shows.id)
1 | John Doe | 5 | Great show! Loved it! | 1
2 | Jane Smith | 4 | Enjoyed the magic tricks! | 1
3 | Alice Johnson | 3 | Good performance but could have been better. | 2
4 | Bob Brown | 2 | Not my cup of tea. | 2
5 | Emma Wilson | 4 | Amazing mime performance! | 3

## Magicians

id | Name | Age | Street_Location
--- | --- | --- | ---
|  |  | (→ Locations.id)
1 | Harry Houdini | 130 | 1
2 | David Copperfield | 65 | 2
3 | Criss Angel | 47 | 3
4 | Dynamo | 39 | 1
5 | Penn & Teller | 75 | 2

## Mimes

id | Name | Age | Street_Location
--- | --- | --- | ---
|  |  | (→ Locations.id)
1 | Marcel Marceau | 88 | 1
2 | Whitey McConnell | 95 | 2
3 | Charlie Chaplin | 130 | 3
4 | Eric Jan De Groot | 70 | 1
5 | Leonard Pitts Jr. | 68 | 2