| 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 |