## Composer

id | name | birth_date | death_date
--- | --- | --- | ---
1 | Composer A | 1900-01-01 | 1980-12-31
2 | Composer B | 1920-01-01 | 2000-12-31

## Conductor

id | name | birth_date | death_date
--- | --- | --- | ---
1 | Conductor C | 1930-01-01 | 2000-12-31
2 | Conductor D | 1940-01-01 | 2020-12-31

## Orchestra

id | name
--- | ---
1 | London Symphony Orchestra
2 | New York Philharmonic

## Opera

id | title | composer_id | conductor_id
--- | --- | --- | ---
|  | (→ Composer.id) | (→ Conductor.id)
1 | Opéra A | 1 | 1
2 | Opéra B | 2 | 2

## Symphony

id | title | composer_id
--- | --- | ---
|  | (→ Composer.id)
1 | Symphony A | 1
2 | Symphony B | 2

## Performance

id | date | symphony_id | orchestra_id | conductor_id
--- | --- | --- | --- | ---
|  | (→ Symphony.id) | (→ Orchestra.id) | (→ Conductor.id)
1 | 2022-06-01 | 1 | 1 | 1
2 | 2022-07-01 | 2 | 2 | 2