## Editors

editor_id | full_name
--- | ---
1 | John Doe
2 | Jane Smith
3 | Michael Brown
4 | Emma White
5 | David Black

## Software_Programs

program_id | name | version
--- | --- | ---
1 | Adobe Premiere | 2021
2 | Final Cut Pro | 2020
3 | DaVinci Resolve | 16
4 | Avid Media Composer | 2020
5 | HitFilm Express | 13

## FilmProjects

project_id | title | release_date
--- | --- | ---
1 | The Shawshank Redemption | 1994-09-22
2 | The Godfather | 1972-03-24
3 | Pulp Fiction | 1994-10-14
4 | Schindler's List | 1993-12-15
5 | Forrest Gump | 1994-07-06

## Directors

director_id | first_name | last_name
--- | --- | ---
1 | Frank | Capra
2 | Martin | Scorsese
3 | Quentin | Tarantino
4 | Steven | Spielberg
5 | Ronald | Reagan

## Actors

actor_id | first_name | last_name
--- | --- | ---
1 | Andy | Dufraine
2 | Tom | Hanks
3 | Leonardo | DiCaprio
4 | Elijah | Wood
5 | Kevin | Costner

## EditorDirectorRelationship

relationship_id | director_id | editor_id
--- | --- | ---
| (→ Directors.director_id) | (→ Editors.editor_id)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5

## ProjectActors

project_actor_id | film_project_id | actor_id
--- | --- | ---
| (→ FilmProjects.project_id) | (→ Actors.actor_id)
1 | 1 | 1
2 | 1 | 2
3 | 2 | None
4 | 3 | None
5 | 4 | None

## DirectorFilmProjects

director_film_project_id | director_id | film_project_id
--- | --- | ---
| (→ Directors.director_id) | (→ FilmProjects.project_id)
1 | 1 | 1
2 | 2 | None
3 | 3 | 3
4 | 4 | None
5 | 5 | None

## EditorSoftwarePrograms

editor_software_program_id | editor_id | software_program_id
--- | --- | ---
| (→ Editors.editor_id) | (→ Software_Programs.program_id)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5
6 | 2 | 1
7 | 3 | 1
8 | 4 | 1
9 | 5 | 1