Genres
| id | name |
| 1 | Action |
| 2 | Drama |
| 3 | Comedy |
| 4 | Horror |
Directors
| id | firstName | lastName |
| 1 | John | Doe |
| 2 | Jane | Smith |
| 3 | Michael | Jackson |
| 4 | Emma | Watson |
Films
| id | title | releaseYear | genreId | directorId |
| | | (→ Genres.id) | (→ Directors.id) |
| 1 | Blockbuster Movie | 2018 | 1 | 1 |
| 2 | Another Blockbuster | 2019 | 2 | 2 |
| 3 | Humorous Comedy | 2020 | 3 | 3 |
| 4 | Scary Horror | 2021 | 4 | 4 |
FilmCrews
| id | filmId | role | crewMemberId |
| (→ Films.id) | | |
| 1 | 1 | Director | 1 |
| 2 | 1 | Producer | 2 |
| 3 | 2 | Director | 1 |
| 4 | 2 | Producer | 3 |
Actors
| id | firstName | lastName |
| 1 | Tom | Hanks |
| 2 | Keanu | Reeves |
| 3 | Leonardo | DiCaprio |
| 4 | Robert | Pattinson |
Casts
| id | filmId | actorId | character |
| (→ Films.id) | (→ Actors.id) | |
| 1 | 1 | 1 | Lead Actor |
| 2 | 1 | 2 | Supporting Role |
| 3 | 2 | 3 | Main Character |
| 4 | 2 | 4 | Villain |
Locations
| id | locationName |
| 1 | New Zealand |
| 2 | Canada |
| 3 | France |
| 4 | Germany |
| 5 | Italy |
FilmingLocations
| id | filmId | locationId |
| (→ Films.id) | (→ Locations.id) |
| 1 | 1 | 1 |
| 2 | 1 | 6 |
| 3 | 2 | 3 |
| 4 | 2 | 7 |
| 5 | 3 | 2 |
| 6 | 3 | 8 |
| 7 | 4 | 4 |
| 8 | 4 | 9 |
SciFi
| id | filmId |
| (→ Films.id) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
Fantasy
| id | filmId |
| (→ Films.id) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |