PerformanceID | TypeOfPerformance | Venue | Date | TicketPrice |
---|---|---|---|---|
1 | Improvised Theatre | Cambridge Theatre | 2021-09-30 00:00:00 | 20.0 |
2 | Improvised Theatre | New York Theater | 2021-09-30 00:00:00 | 25.0 |
3 | Musical | Cambridge Theatre | 2021-10-07 00:00:00 | 30.0 |
4 | Musical | London Opera House | 2021-10-08 00:00:00 | 40.0 |
ActorID | FirstName | LastName | BirthDate | Nationality |
---|---|---|---|---|
1 | John | Doe | 1980-01-01 | American |
2 | Jane | Smith | 1985-06-15 | British |
RoleID | Name | Description |
---|---|---|
1 | Hamlet | The Prince of Denmark. |
2 | Macbeth | A Scottish nobleman who becomes the King of Scotland. |
CastingID | ActorID | RoleID |
---|---|---|
(→ Actors.ActorID) | (→ Roles.RoleID) | |
1 | 1 | 1 |
2 | 2 | 2 |
ShowID | Title | Genre | Director | ReleaseYear |
---|---|---|---|---|
1 | Hamlet | Tragedy | William Shakespeare | 1603 |
2 | Macbeth | Tragedy | William Shakespeare | 1606 |
PerformanceShowID | PerformanceID | ShowID |
---|---|---|
(→ Performances.PerformanceID) | (→ Shows.ShowID) | |
1 | 1 | 1 |
2 | 2 | 2 |