## Roles

id | Role
--- | ---
1 | Actor
2 | Director

## People

id | Name | Birth_year
--- | --- | ---
1 | John Doe | 1975
2 | Jane Smith | 1980

## Movies

id | Title | Release_date
--- | --- | ---
1 | Movie1 | 2000-01-01
2 | Movie2 | 2005-06-01

## MovieRoles

MovieId | PersonId | RoleId
--- | --- | ---
(→ Movies.id) | (→ People.id) | (→ Roles.id)
1 | 1 | 1
2 | 2 | 1
3 | 1 | 2
4 | 2 | 2

## DirectorMovies

DirectorId | MovieId
--- | ---
(→ People.id) | (→ Movies.id)
1 | 1
2 | 2

## ActorMovies

ActorId | MovieId
--- | ---
(→ People.id) | (→ Movies.id)
1 | 1
2 | 2
3 | 3
4 | 4