## Directors

id | name | age
--- | --- | ---
1 | John Doe | 45
2 | Jane Smith | 30

## Movies

id | title | release_year | director_id
--- | --- | --- | ---
|  |  | (→ Directors.id)
1 | Film A | 2010 | 1
2 | Film B | 2015 | 2

## Actors

id | name | age
--- | --- | ---
1 | Alice Johnson | 45
2 | Bob Brown | 30

## MovieActors

movie_id | actor_id | role
--- | --- | ---
(→ Movies.id) | (→ Actors.id) |
1 | 1 | Lead
1 | 2 | Supporting
2 | 1 | Lead
2 | 2 | Supporting

## Departments

department_name
Script Supervision
Costume Design

## DepartmentMembers

member_id | department_name | role
--- | --- | ---
(→ Actors.id) |  |
1 | Script Supervision | Supervisor
2 | Script Supervision | Assistant
1 | Costume Design | Head of Costumes
2 | Costume Design | Costume Designer