FilmMakers

idName
1Alice
2Bob

CastingDirectors

idFK_FilmMakerIdName
(→ FilmMakers.id)
11Charlie
22Dave

LocationScouts

idFK_FilmMakerIdName
(→ FilmMakers.id)
11Eva
22Frank

Salaries

idAmount
180000
290000
370000
460000
550000

DirectorSalaries

FilmMakerIDSalaryID
(→ FilmMakers.id)(→ Salaries.id)
11
23
14
22

ScoutSalaries

FilmMakerIDSalaryID
(→ FilmMakers.id)(→ Salaries.id)
11
24
12
25

Directors

idNameSalaryID
(→ Salaries.id)
1George1
2Hannah2
3Irving3
4Julia4
5Keith5

Scouts

idNameSalaryID
(→ Salaries.id)
1Lisa1
2Max2
3Nina3
4Oscar4
5Patrick5

Genre

idType
1Action
2Comedy
3Drama
4Horror
5Romance

Films

idTitleReleaseYearFK_GenreId
(→ Genre.id)
1Awesome Movie20211
2Funny Comedy20222
3Exciting Drama20233
4Spooky Horror20244
5Love Story20255

DirectedBy

FilmIDDirectorID
(→ Films.id)(→ Directors.id)
11
22
33
44
55