| 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 |
| 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. |
| id | PerformanceId | Composer | Lyricist |
|---|---|---|---|
| (→ Performances.id) | |||
| 1 | 1 | Stephen Sondheim | George Furth |
| 2 | 2 | Andrew Lloyd Webber | Tim Rice |
| id | Name |
|---|---|
| 1 | Cambridge Theatre |
| 2 | Her Majesty's Theatre |
| id | VenueId | PerformanceId |
|---|---|---|
| (→ Venues.id) | (→ Performances.id) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |