Director

idnameyears_of_experience
1Alfred Hitchcock20
2Stanley Kubrick30

Cinematographer

idnameyears_of_experience
1Roger Deakins20
2Emmanuel Lubezki18

Film

idtitlerelease_yeardirector_idcinematographer_id
(→ Director.id)(→ Cinematographer.id)
1Psycho19601None
2The Shining19802None
3Blade Runner198221

Actor

idname
1Harrison Ford
2Tom Cruise

Character

idcharacter_namefilm_idactor_id
(→ Film.id)(→ Actor.id)
1Deckard11
2Jack Torrance22
3Gaff31

Award

idaward_typefilm_idyear
(→ Film.id)
1Best Picture11961
2Best Direction11961
3Best Adapted Screenplay11961
4Best Cinematography31983
5Best Visual Effects11961