Categories

idcategoryName
1Fantasy
2Horror

Films

idtitlebudgetcategoryId
(→ Categories.id)
1Lord of the Rings20000000.01
2Harry Potter30000000.01
3The Shining20000000.02
4It18000000.02

Actors

idfirstNamelastName
1LeonardoDiCaprio
2MerylStreep

Directors

iddirectorName
1Peter Jackson
2Christopher Nolan

Roles

filmIdactorIdroleTypedirectorId
(→ Films.id)(→ Actors.id)(→ Directors.id)
11Leading Role1
22Supporting Role2
12Villain1
31Leading Role1
42Supporting Role2