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 |