Casting_Directors

IDNameContact
1John Doe+123-4567890
2Jane Smith+098-7654321
3Alice Brown+777-6665554
4Bob Johnson+555-4443332
5Charlie White+111-2221110

Actors

IDActorTypeNameAgeContact
1LeadTom Hanks55+123-4567890
2SupportingMeryl Streep68+098-7654321
3ChildEmma Watson18+777-6665554
4ExtrasRobert Downey Jr.54+555-4443332
5BackgroundScarlett Johansson36+111-2221110

Films

IDTitleReleaseYearDirectorID
(→ Casting_Directors.ID)
1Forrest Gump19941
2The Devil Wears Prada20062
3Harry Potter and the Sorcerer's Stone20013
4Iron Man20084
5Avengers: Endgame20195

Roles

IDFilmIDRoleName
(→ Films.ID)
11Gump
21Lyndon B. Johnson
32Miranda Priestly
42Andy Sachs
53Harry Potter

Assignments

IDActorIDRoleID
(→ Actors.ID)(→ Roles.ID)
111
222
333
444
555

Child_Performers

IDActorIDGuardianContact
(→ Actors.ID)
13+123-4567890

Casting_Directors_Actors

CDIDActorID
(→ Casting_Directors.ID)(→ Actors.ID)
11
12
23
24
35