## Casting_Directors

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

## Actors

ID | ActorType | Name | Age | Contact
--- | --- | --- | --- | ---
1 | Lead | Tom Hanks | 55 | +123-4567890
2 | Supporting | Meryl Streep | 68 | +098-7654321
3 | Child | Emma Watson | 18 | +777-6665554
4 | Extras | Robert Downey Jr. | 54 | +555-4443332
5 | Background | Scarlett Johansson | 36 | +111-2221110

## Films

ID | Title | ReleaseYear | DirectorID
--- | --- | --- | ---
|  |  | (→ Casting_Directors.ID)
1 | Forrest Gump | 1994 | 1
2 | The Devil Wears Prada | 2006 | 2
3 | Harry Potter and the Sorcerer's Stone | 2001 | 3
4 | Iron Man | 2008 | 4
5 | Avengers: Endgame | 2019 | 5

## Roles

ID | FilmID | RoleName
--- | --- | ---
| (→ Films.ID) |
1 | 1 | Gump
2 | 1 | Lyndon B. Johnson
3 | 2 | Miranda Priestly
4 | 2 | Andy Sachs
5 | 3 | Harry Potter

## Assignments

ID | ActorID | RoleID
--- | --- | ---
| (→ Actors.ID) | (→ Roles.ID)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5

## Child_Performers

ID | ActorID | GuardianContact
--- | --- | ---
| (→ Actors.ID) |
1 | 3 | +123-4567890

## Casting_Directors_Actors

CDID | ActorID
--- | ---
(→ Casting_Directors.ID) | (→ Actors.ID)
1 | 1
1 | 2
2 | 3
2 | 4
3 | 5