## Filmmaker

id | name | birth_year
--- | --- | ---
1 | Alfred Hitchcock | 1899
2 | Quentin Tarantino | 1963
3 | Christopher Nolan | 1970
4 | Martin Scorsese | 1942
5 | Stanley Kubrick | 1928

## Screenwriter

id | name | birth_year
--- | --- | ---
1 | Joseph Stefano | 1922
2 | Quentin Tarantino | 1963
3 | Jonathan Nolan | 1976
4 | Paul Schrader | 1946
5 | David Webb Peoples | 1941

## Movie

id | title | release_date | filmmaker_id | screenwriter_id
--- | --- | --- | --- | ---
|  |  | (→ Filmmaker.id) | (→ Screenwriter.id)
1 | Psycho | 1960-06-16 | 1 | 1
2 | Inglourious Basterds | 2009-08-20 | 2 | 2
3 | The Prestige | 2006-10-19 | 3 | 3
4 | Taxi Driver | 1976-02-08 | 4 | 5
5 | Blade Runner | 1982-06-25 | 4 | 6

## Genre

id | genre_name
--- | ---
1 | Thriller
2 | Crime
3 | Drama
4 | Science Fiction
5 | Action

## Actor

id | name | birth_year
--- | --- | ---
1 | Leonardo DiCaprio | 1974
2 | Joseph Gordon-Levitt | 1981
3 | Tom Hardy | 1977
4 | Cate Blanchett | 1969
5 | Kristen Scott Thomas | 1960

## Cast

movie_id | actor_id | role
--- | --- | ---
(→ Movie.id) | (→ Actor.id) |
1 | 1 | Norman Bates
1 | 2 | Marion Crane
2 | 1 | Fredric Quentlin
2 | 3 | Brad Pitt
3 | 4 | Robert Angier