FilmCrewMembers

MemberIDFirstNameLastNameDateOfBirth
1JohnDoe1987-06-13
2JaneSmith1990-08-20
3EmmaNguyen1985-10-25
4MichaelJackson1992-11-21
5OliviaMartinez1988-03-17

VisualDesignRoles

RoleIDRoleName
1Art Director
2Set Designer
3Production Designer
4Costume Designer
5Lighting Designer

Films

FilmIDTitleReleaseYearGenreBudgetBoxOffice
1The Dark Knight2008Action/Adventure185000000.01004053541.0
2Avatar2009Science Fiction237000000.02785000000.0
3Titanic1997Romance/Drama200000000.02202000000.0
4La La Land2016Musical/Romance30000000.0445500001.0
5Black Panther2018Superhero200000000.01372213784.0

WorksIn

MemberIDFilmID
(→ FilmCrewMembers.MemberID)(→ Films.FilmID)
11
22
33
44
55

RolesInFilms

RoleIDFilmIDNumberOfFilmsWorkedOn
(→ VisualDesignRoles.RoleID)(→ Films.FilmID)
1125
1215
2325
2410
355