## Performances

id | Title | Date | StartTime
--- | --- | --- | ---
1 | Hamlet | 2021-12-30 | 19:30
2 | Wicked | 2021-12-31 | 19:30
3 | Phantom of The Opera | 2022-01-01 | 19:30
4 | Mamma Mia! | 2022-01-02 | 19:30
5 | Lion King | 2022-01-03 | 19:30

## Improvised_Theatres

id | PerformanceId | Name | Description
--- | --- | --- | ---
| (→ Performances.id) |  |
1 | 1 | Comedy Club | A popular venue for stand-up comedy shows.
2 | 2 | Open Stage | An intimate theatre where actors can perform their own material.

## Musicals

id | PerformanceId | Composer | Lyricist
--- | --- | --- | ---
| (→ Performances.id) |  |
1 | 1 | Stephen Sondheim | George Furth
2 | 2 | Andrew Lloyd Webber | Tim Rice

## Venues

id | Name
--- | ---
1 | Cambridge Theatre
2 | Her Majesty's Theatre

## Showings

id | VenueId | PerformanceId
--- | --- | ---
| (→ Venues.id) | (→ Performances.id)
1 | 1 | 1
2 | 2 | 2