Genres

idname
1Action
2Drama
3Comedy
4Horror

Directors

idfirstNamelastName
1JohnDoe
2JaneSmith
3MichaelJackson
4EmmaWatson

Films

idtitlereleaseYeargenreIddirectorId
(→ Genres.id)(→ Directors.id)
1Blockbuster Movie201811
2Another Blockbuster201922
3Humorous Comedy202033
4Scary Horror202144

FilmCrews

idfilmIdrolecrewMemberId
(→ Films.id)
11Director1
21Producer2
32Director1
42Producer3

Actors

idfirstNamelastName
1TomHanks
2KeanuReeves
3LeonardoDiCaprio
4RobertPattinson

Casts

idfilmIdactorIdcharacter
(→ Films.id)(→ Actors.id)
111Lead Actor
212Supporting Role
323Main Character
424Villain

Locations

idlocationName
1New Zealand
2Canada
3France
4Germany
5Italy

FilmingLocations

idfilmIdlocationId
(→ Films.id)(→ Locations.id)
111
216
323
427
532
638
744
849

SciFi

idfilmId
(→ Films.id)
11
22
33
44

Fantasy

idfilmId
(→ Films.id)
11
22
33
44