## Directors

id | name | years_of_experience | filmography
--- | --- | --- | ---
1 | John Doe | 20 | Movie A, Movie B
2 | Jane Smith | 30 | Film X, Film Y

## Cinematographers

id | name | years_of_experience | films_worked_on
--- | --- | --- | ---
1 | Alice Johnson | 20 | Project Z, Project W
2 | Bob Brown | 25 | The Sunset, The Dawn

## Films

id | title | director_id | cinematographer_id
--- | --- | --- | ---
|  | (→ Directors.id) | (→ Cinematographers.id)
1 | Epic Adventure | 1 | 1
2 | Thrilling Mystery | 2 | 2

## ProductionHouses

id | name | number_of_films
--- | --- | ---
1 | Studio Alpha | 8
2 | Big Screen Productions | 10

## FilmsAndProductionHouses

id | film_id | production_house_id
--- | --- | ---
| (→ Films.id) | (→ ProductionHouses.id)
1 | 1 | 1
2 | 2 | 2

## FilmCrewMembers

id | crew_member | years_of_experience | experience_details
--- | --- | --- | ---
1 | Director | 20 | Over a decade of directing movies.
2 | Director | 15 | Multiple awards won for direction.
3 | Cinematographer | 20 | Wide range of lighting techniques used.
4 | Cinematographer | 17 | Worked on various genres.