## Genres

id | name
--- | ---
1 | Drama
2 | Romance

## Music_Composers

id | composer_name
--- | ---
1 | Hans Zimmer
2 | John Williams
3 | Danny Elfman

## Films

id | title | release_year
--- | --- | ---
1 | The Dark Knight | 2008
2 | Titanic | 1997
3 | Beauty and the Beast | 1991

## Film_Genres

film_id | genre_id
--- | ---
(→ Films.id) | (→ Genres.id)
1 | 1
2 | 2
3 | 1
3 | 2

## Composer_Films

composer_id | film_id | score_composed
--- | --- | ---
(→ Music_Composers.id) | (→ Films.id) |
1 | 1 | 1
2 | 2 | 0
3 | 3 | 1
1 | 3 | 0