## Music_Composers

id | composer_name
--- | ---
1 | Hans Zimmer
2 | John Williams

## Movies

id | title | genre
--- | --- | ---
|  | (→ Genres.type)
1 | Inception | Action/Adventure
2 | Star Wars | Science Fiction

## Dramas

id | movie_id | music_composer_id
--- | --- | ---
| (→ Movies.id) | (→ Music_Composers.id)
1 | 1 | 1
2 | 2 | 2

## Romances

id | movie_id | music_composer_id
--- | --- | ---
| (→ Movies.id) | (→ Music_Composers.id)
1 | 3 | 1
2 | 4 | 2

## Scenes

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

## MovieScenes

id | movie_id | scene_id
--- | --- | ---
| (→ Movies.id) | (→ Scenes.id)
1 | 1 | 1
2 | 1 | 2
3 | 3 | 1
4 | 3 | 2

## Genres

type | id
--- | ---
Action/Adventure | 1
Science Fiction | 2