## Composers

composerId | name | birthYear
--- | --- | ---
1 | Wolfgang Amadeus Mozart | 1756
2 | George Frideric Handel | 1685

## Operas

operaID | title | Historical_Era | Location | Duration | composerId
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Composers.composerId)
1 | The Marriage of Figaro | Classical | Seville | 300 | 1
2 | Messiah | Baroque | Jerusalem | 220 | 2

## Venues

venueID | name | capacity
--- | --- | ---
1 | Metropolitan Opera House | 3938
2 | Royal Opera House | 2100

## Performances

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

## CastMembers

castMemberId | name | roleInPerformance | performanceId
--- | --- | --- | ---
|  |  | (→ Performances.performanceId)
1 | Jane Doe | Figaro | 1
2 | John Smith | Count Almaviva | 1