Genres

idname
1Drama
2Romance

Music_Composers

idcomposer_name
1Hans Zimmer
2John Williams
3Danny Elfman

Films

idtitlerelease_year
1The Dark Knight2008
2Titanic1997
3Beauty and the Beast1991

Film_Genres

film_idgenre_id
(→ Films.id)(→ Genres.id)
11
22
31
32

Composer_Films

composer_idfilm_idscore_composed
(→ Music_Composers.id)(→ Films.id)
111
220
331
130