| id | Name | Age | Street_Location |
|---|---|---|---|
| (→ Locations.Name) | |||
| 1 | Harry Houdini | 130 | Times Square, New York |
| 2 | David Copperfield | 65 | Bryant Park, New York |
| 3 | Criss Angel | 47 | Central Park, New York |
| 4 | Dynamo | 39 | Times Square, New York |
| 5 | Penn & Teller | 75 | Bryant Park, New York |
| id | Name | Age | Street_Location |
|---|---|---|---|
| (→ Locations.Name) | |||
| 1 | Marcel Marceau | 88 | Times Square, New York |
| 2 | Whitey McConnell | 95 | Bryant Park, New York |
| 3 | Charlie Chaplin | 130 | Central Park, New York |
| 4 | Eric Jan De Groot | 70 | Times Square, New York |
| 5 | Leonard Pitts Jr. | 68 | Bryant Park, New York |
| id | LocationName |
|---|---|
| 1 | Times Square, New York |
| 2 | Bryant Park, New York |
| 3 | Central Park, New York |
| 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 |
| 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 |
| 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 |