## Directors

id | name | birthdate
--- | --- | ---
1 | John Doe | 1970-01-01
2 | Jane Smith | 1980-02-02

## Actors

id | name | birthdate
--- | --- | ---
1 | Alice Johnson | 1990-03-03
2 | Bob Brown | 1985-04-04

## Roles

id | movieId | actorId | roleName
--- | --- | --- | ---
| (→ Movies.id) | (→ Actors.id) |
1 | 1 | 1 | Lead Actor
2 | 2 | 2 | Supporting Actor

## Genres

id | genreName
--- | ---
1 | Sci-Fi
2 | Fantasy

## Films

id | title | releaseDate | directorId | genreId | filmingLocation
--- | --- | --- | --- | --- | ---
|  |  | (→ Directors.id) | (→ Genres.id) |
1 | Movie1 | 2020-01-01 | 1 | 1 | New Zealand
2 | Movie2 | 2021-02-02 | 2 | 2 | Not New Zealand
3 | Movie3 | 2019-03-03 | 1 | 2 | New Zealand
4 | Movie4 | 2022-04-04 | 2 | 1 | Not New Zealand