Directors

idnameage
1John Doe45
2Jane Smith30

Movies

idtitlerelease_yeardirector_id
(→ Directors.id)
1Film A20101
2Film B20152

Actors

idnameage
1Alice Johnson45
2Bob Brown30

MovieActors

movie_idactor_idrole
(→ Movies.id)(→ Actors.id)
11Lead
12Supporting
21Lead
22Supporting

Departments

department_name
Script Supervision
Costume Design

DepartmentMembers

member_iddepartment_namerole
(→ Actors.id)
1Script SupervisionSupervisor
2Script SupervisionAssistant
1Costume DesignHead of Costumes
2Costume DesignCostume Designer