Music_Composers

idcomposer_name
1Hans Zimmer
2John Williams

Movies

idtitlegenre
(→ Genres.type)
1InceptionAction/Adventure
2Star WarsScience Fiction

Dramas

idmovie_idmusic_composer_id
(→ Movies.id)(→ Music_Composers.id)
111
222

Romances

idmovie_idmusic_composer_id
(→ Movies.id)(→ Music_Composers.id)
131
242

Scenes

idscene_description
1A thrilling car chase through the streets of Los Angeles.
2The protagonist confronts their inner demons on a deserted mountain top.

MovieScenes

idmovie_idscene_id
(→ Movies.id)(→ Scenes.id)
111
212
331
432

Genres

typeid
Action/Adventure1
Science Fiction2