## Director

id | name | years_of_experience
--- | --- | ---
1 | Alfred Hitchcock | 20
2 | Stanley Kubrick | 30

## Cinematographer

id | name | years_of_experience
--- | --- | ---
1 | Roger Deakins | 20
2 | Emmanuel Lubezki | 18

## Film

id | title | release_year | director_id | cinematographer_id
--- | --- | --- | --- | ---
|  |  | (→ Director.id) | (→ Cinematographer.id)
1 | Psycho | 1960 | 1 | None
2 | The Shining | 1980 | 2 | None
3 | Blade Runner | 1982 | 2 | 1

## Actor

id | name
--- | ---
1 | Harrison Ford
2 | Tom Cruise

## Character

id | character_name | film_id | actor_id
--- | --- | --- | ---
|  | (→ Film.id) | (→ Actor.id)
1 | Deckard | 1 | 1
2 | Jack Torrance | 2 | 2
3 | Gaff | 3 | 1

## Award

id | award_type | film_id | year
--- | --- | --- | ---
|  | (→ Film.id) |
1 | Best Picture | 1 | 1961
2 | Best Direction | 1 | 1961
3 | Best Adapted Screenplay | 1 | 1961
4 | Best Cinematography | 3 | 1983
5 | Best Visual Effects | 1 | 1961