## Studio

id | name | location
--- | --- | ---
1 | Warner Bros. | Burbank, CA
2 | Disney | Burbank, CA
3 | Universal Pictures | Universal City, CA
4 | Paramount Pictures | Hollywood, CA
5 | 20th Century Fox | Century City, CA

## Director

id | name | birth_year
--- | --- | ---
1 | Christopher Nolan | 1970
2 | Quentin Tarantino | 1963
3 | Steven Spielberg | 1946
4 | James Cameron | 1954
5 | Martin Scorsese | 1942

## Movie

id | title | release_date | studio_id | director_id
--- | --- | --- | --- | ---
|  |  | (→ Studio.id) | (→ Director.id)
1 | Inception | 2010-07-16 | 1 | 1
2 | Pulp Fiction | 1994-10-14 | 2 | 2
3 | Schindler's List | 1993-12-15 | 3 | 3
4 | Titanic | 1997-12-18 | 4 | 4
5 | Goodfellas | 1990-09-22 | 2 | 5

## Actor

id | first_name | last_name | date_of_birth
--- | --- | --- | ---
1 | Leonardo | DiCaprio | 1974-11-11
2 | Tom | Cruise | 1962-07-03
3 | Brad | Pitt | 1963-12-18
4 | Joaquin | Phoenix | 1974-10-28

## Role

movie_id | actor_id | character
--- | --- | ---
(→ Movie.id) | (→ Actor.id) |
1 | 1 | Dom Cobb
2 | 2 | Vincent Vega
3 | 3 | Oskar Schindler
4 | 4 | Jack Dawson
2 | 5 | Jules Winnfield

## Genre

genre_id | name
--- | ---
1 | Action
2 | Drama
3 | Romance
4 | Thriller
5 | Crime

## MovieGenre

movie_id | genre_id
--- | ---
(→ Movie.id) | (→ Genre.genre_id)
1 | 1
1 | 3
2 | 2
3 | 4
4 | 5