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 |