| id | name | years_of_experience | filmography |
|---|---|---|---|
| 1 | John Doe | 20 | Movie A, Movie B |
| 2 | Jane Smith | 30 | Film X, Film Y |
| id | name | years_of_experience | films_worked_on |
|---|---|---|---|
| 1 | Alice Johnson | 20 | Project Z, Project W |
| 2 | Bob Brown | 25 | The Sunset, The Dawn |
| id | title | director_id | cinematographer_id |
|---|---|---|---|
| (→ Directors.id) | (→ Cinematographers.id) | ||
| 1 | Epic Adventure | 1 | 1 |
| 2 | Thrilling Mystery | 2 | 2 |
| id | name | number_of_films |
|---|---|---|
| 1 | Studio Alpha | 8 |
| 2 | Big Screen Productions | 10 |
| id | film_id | production_house_id |
|---|---|---|
| (→ Films.id) | (→ ProductionHouses.id) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 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. |