Director
id | name |
1 | Christopher Nolan |
2 | Quentin Tarantino |
3 | Steven Spielberg |
4 | Guillermo del Toro |
5 | Martin Scorsese |
6 | Ava DuVernay |
Film
id | title | release_date | director_id |
| | | (→ Director.id) |
1 | Inception | 2010-07-16 | 1 |
2 | Pulp Fiction | 1994-10-14 | 2 |
3 | Schindler’s List | 1993-12-15 | 3 |
4 | Pan’s Labyrinth | 2006-03-17 | 4 |
5 | The Departed | 2006-08-04 | 5 |
Movie_Elements
element_type | movie_title | composer_id | duration |
| | (→ Composer.id) | |
Sound Design | Inception | 6 | 140 |
Sound Design | Inception | 1 | 150 |
Music Score | Schindler’s List | 1 | 150 |
Music Score | Pan’s Labyrinth | 7 | 120 |
Music Score | The Departed | 4 | 130 |
Composer
id | creator | birth_year | death_year |
1 | John Williams | 1932 | None |
2 | Hans Zimmer | 1957 | None |
3 | Danny Elfman | 1953 | None |
4 | Howard Shore | 1946 | None |
5 | Thomas Newman | 1955 | None |
6 | Zack Hemsey | 1983 | None |
7 | Javier Navarrete | 1956 | None |