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 |