ArtistID | Name |
---|---|
1 | John Doe |
2 | Jane Smith |
3 | Michael Johnson |
4 | Emily Davis |
5 | William Brown |
ComedianID | ArtistID | StageName |
---|---|---|
(→ Artists.ArtistID) | ||
1 | 1 | Chris Rock |
2 | 2 | Ellen DeGeneres |
3 | 3 | Kevin Hart |
4 | 4 | Amy Schumer |
5 | 5 | Dave Chappelle |
MagicianID | ArtistID | MagicName |
---|---|---|
(→ Artists.ArtistID) | ||
1 | 1 | David Copperfield |
2 | 2 | Penn & Teller |
3 | 3 | Criss Angel |
4 | 4 | Dynamo |
5 | 5 | Derren Brown |
EventID | Title | Description | StartDate | EndDate | Location |
---|---|---|---|---|---|
1 | Big Comedy Night | The biggest comedy event of the year! | 2022-08-01 | 2022-08-02 | New York City |
2 | Great Magic Extravaganza | Experience the magic like never before! | 2022-09-01 | 2022-09-02 | Las Vegas |
PerformanceID | EventID | DurationOfPerformance |
---|---|---|
(→ Events.EventID) | ||
1 | 1 | 60 |
2 | 2 | 75 |
3 | 1 | 45 |
4 | 2 | 60 |
5 | 1 | 90 |
6 | 2 | 75 |
ShowID | PerformanceID | ComedianID |
---|---|---|
(→ Performances.PerformanceID) | (→ StandUpComedians.ComedianID) | |
1 | 1 | 1 |
2 | 1 | 2 |
3 | 2 | 3 |
4 | 3 | 4 |
5 | 4 | 5 |
6 | 5 | 1 |
ShowID | PerformanceID | MagicianID |
---|---|---|
(→ Performances.PerformanceID) | (→ Magicians.MagicianID) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |