Directors

idnameyears_of_experiencefilmography
1John Doe20Movie A, Movie B
2Jane Smith30Film X, Film Y

Cinematographers

idnameyears_of_experiencefilms_worked_on
1Alice Johnson20Project Z, Project W
2Bob Brown25The Sunset, The Dawn

Films

idtitledirector_idcinematographer_id
(→ Directors.id)(→ Cinematographers.id)
1Epic Adventure11
2Thrilling Mystery22

ProductionHouses

idnamenumber_of_films
1Studio Alpha8
2Big Screen Productions10

FilmsAndProductionHouses

idfilm_idproduction_house_id
(→ Films.id)(→ ProductionHouses.id)
111
222

FilmCrewMembers

idcrew_memberyears_of_experienceexperience_details
1Director20Over a decade of directing movies.
2Director15Multiple awards won for direction.
3Cinematographer20Wide range of lighting techniques used.
4Cinematographer17Worked on various genres.