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 |