composerId | name | birthYear |
---|---|---|
1 | Wolfgang Amadeus Mozart | 1756 |
2 | George Frideric Handel | 1685 |
operaID | title | Historical_Era | Location | Duration | composerId |
---|---|---|---|---|---|
(→ Composers.composerId) | |||||
1 | The Marriage of Figaro | Classical | Seville | 300 | 1 |
2 | Messiah | Baroque | Jerusalem | 220 | 2 |
venueID | name | capacity |
---|---|---|
1 | Metropolitan Opera House | 3938 |
2 | Royal Opera House | 2100 |
performanceId | date | startTime | venueId | operaId |
---|---|---|---|---|
(→ Venues.venueId) | (→ Operas.operaId) | |||
1 | 2022-10-15 | 19:30 | 1 | 1 |
2 | 2022-11-20 | 18:00 | 2 | 2 |
castMemberId | name | roleInPerformance | performanceId |
---|---|---|---|
(→ Performances.performanceId) | |||
1 | Jane Doe | Figaro | 1 |
2 | John Smith | Count Almaviva | 1 |