Editors

editor_idfull_name
1John Doe
2Jane Smith
3Michael Brown
4Emma White
5David Black

Software_Programs

program_idnameversion
1Adobe Premiere2021
2Final Cut Pro2020
3DaVinci Resolve16
4Avid Media Composer2020
5HitFilm Express13

FilmProjects

project_idtitlerelease_date
1The Shawshank Redemption1994-09-22
2The Godfather1972-03-24
3Pulp Fiction1994-10-14
4Schindler's List1993-12-15
5Forrest Gump1994-07-06

Directors

director_idfirst_namelast_name
1FrankCapra
2MartinScorsese
3QuentinTarantino
4StevenSpielberg
5RonaldReagan

Actors

actor_idfirst_namelast_name
1AndyDufraine
2TomHanks
3LeonardoDiCaprio
4ElijahWood
5KevinCostner

EditorDirectorRelationship

relationship_iddirector_ideditor_id
(→ Directors.director_id)(→ Editors.editor_id)
111
222
333
444
555

ProjectActors

project_actor_idfilm_project_idactor_id
(→ FilmProjects.project_id)(→ Actors.actor_id)
111
212
32None
43None
54None

DirectorFilmProjects

director_film_project_iddirector_idfilm_project_id
(→ Directors.director_id)(→ FilmProjects.project_id)
111
22None
333
44None
55None

EditorSoftwarePrograms

editor_software_program_ideditor_idsoftware_program_id
(→ Editors.editor_id)(→ Software_Programs.program_id)
111
222
333
444
555
621
731
841
951