Performances

PerformanceIDTypeOfPerformanceVenueDateTicketPrice
1Improvised TheatreCambridge Theatre2021-09-30 00:00:0020.0
2Improvised TheatreNew York Theater2021-09-30 00:00:0025.0
3MusicalCambridge Theatre2021-10-07 00:00:0030.0
4MusicalLondon Opera House2021-10-08 00:00:0040.0

Actors

ActorIDFirstNameLastNameBirthDateNationality
1JohnDoe1980-01-01American
2JaneSmith1985-06-15British

Roles

RoleIDNameDescription
1HamletThe Prince of Denmark.
2MacbethA Scottish nobleman who becomes the King of Scotland.

Casting

CastingIDActorIDRoleID
(→ Actors.ActorID)(→ Roles.RoleID)
111
222

Shows

ShowIDTitleGenreDirectorReleaseYear
1HamletTragedyWilliam Shakespeare1603
2MacbethTragedyWilliam Shakespeare1606

PerformancesInShows

PerformanceShowIDPerformanceIDShowID
(→ Performances.PerformanceID)(→ Shows.ShowID)
111
222