| composer_id | name | birth_year | death_year |
|---|---|---|---|
| 1 | John Williams | 1932 | 2020 |
| 2 | Hans Zimmer | 1957 | Present |
| 3 | James Horner | 1953 | 1996 |
| 4 | Danny Elfman | 1953 | Present |
| 5 | Howard Shore | 1946 | Present |
| instrument_id | instrument_name |
|---|---|
| 1 | Piano |
| 2 | Guitar |
| 3 | Violin |
| 4 | Cello |
| 5 | Flute |
| composers_instruments_id | composer_id | instrument_id |
|---|---|---|
| (→ Composers.composer_id) | (→ Instruments.instrument_id) | |
| 1 | 1 | 1 |
| 2 | 2 | 1 |
| 3 | 3 | 1 |
| 4 | 4 | 1 |
| 5 | 5 | 1 |