Composers

composerIdnamebirthYear
1Wolfgang Amadeus Mozart1756
2George Frideric Handel1685

Operas

operaIDtitleHistorical_EraLocationDurationcomposerId
(→ Composers.composerId)
1The Marriage of FigaroClassicalSeville3001
2MessiahBaroqueJerusalem2202

Venues

venueIDnamecapacity
1Metropolitan Opera House3938
2Royal Opera House2100

Performances

performanceIddatestartTimevenueIdoperaId
(→ Venues.venueId)(→ Operas.operaId)
12022-10-1519:3011
22022-11-2018:0022

CastMembers

castMemberIdnameroleInPerformanceperformanceId
(→ Performances.performanceId)
1Jane DoeFigaro1
2John SmithCount Almaviva1