| id | name |
|---|---|
| 1 | Drama |
| 2 | Romance |
| id | composer_name |
|---|---|
| 1 | Hans Zimmer |
| 2 | John Williams |
| 3 | Danny Elfman |
| id | title | release_year |
|---|---|---|
| 1 | The Dark Knight | 2008 |
| 2 | Titanic | 1997 |
| 3 | Beauty and the Beast | 1991 |
| film_id | genre_id |
|---|---|
| (→ Films.id) | (→ Genres.id) |
| 1 | 1 |
| 2 | 2 |
| 3 | 1 |
| 3 | 2 |
| composer_id | film_id | score_composed |
|---|---|---|
| (→ Music_Composers.id) | (→ Films.id) | |
| 1 | 1 | 1 |
| 2 | 2 | 0 |
| 3 | 3 | 1 |
| 1 | 3 | 0 |