Composer

idnamebirth_datedeath_date
1Composer A1900-01-011980-12-31
2Composer B1920-01-012000-12-31

Conductor

idnamebirth_datedeath_date
1Conductor C1930-01-012000-12-31
2Conductor D1940-01-012020-12-31

Orchestra

idname
1London Symphony Orchestra
2New York Philharmonic

Opera

idtitlecomposer_idconductor_id
(→ Composer.id)(→ Conductor.id)
1Opéra A11
2Opéra B22

Symphony

idtitlecomposer_id
(→ Composer.id)
1Symphony A1
2Symphony B2

Performance

iddatesymphony_idorchestra_idconductor_id
(→ Symphony.id)(→ Orchestra.id)(→ Conductor.id)
12022-06-01111
22022-07-01222