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 |