| 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 |