Performances

idTitleDateStartTime
1Hamlet2021-12-3019:30
2Wicked2021-12-3119:30
3Phantom of The Opera2022-01-0119:30
4Mamma Mia!2022-01-0219:30
5Lion King2022-01-0319:30

Improvised_Theatres

idPerformanceIdNameDescription
(→ Performances.id)
11Comedy ClubA popular venue for stand-up comedy shows.
22Open StageAn intimate theatre where actors can perform their own material.

Musicals

idPerformanceIdComposerLyricist
(→ Performances.id)
11Stephen SondheimGeorge Furth
22Andrew Lloyd WebberTim Rice

Venues

idName
1Cambridge Theatre
2Her Majesty's Theatre

Showings

idVenueIdPerformanceId
(→ Venues.id)(→ Performances.id)
111
222