## Performances

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

## Actors

ActorID | FirstName | LastName | BirthDate | Nationality
--- | --- | --- | --- | ---
1 | John | Doe | 1980-01-01 | American
2 | Jane | Smith | 1985-06-15 | British

## Roles

RoleID | Name | Description
--- | --- | ---
1 | Hamlet | The Prince of Denmark.
2 | Macbeth | A Scottish nobleman who becomes the King of Scotland.

## Casting

CastingID | ActorID | RoleID
--- | --- | ---
| (→ Actors.ActorID) | (→ Roles.RoleID)
1 | 1 | 1
2 | 2 | 2

## Shows

ShowID | Title | Genre | Director | ReleaseYear
--- | --- | --- | --- | ---
1 | Hamlet | Tragedy | William Shakespeare | 1603
2 | Macbeth | Tragedy | William Shakespeare | 1606

## PerformancesInShows

PerformanceShowID | PerformanceID | ShowID
--- | --- | ---
| (→ Performances.PerformanceID) | (→ Shows.ShowID)
1 | 1 | 1
2 | 2 | 2