## ArtDirectors

ID | Name | Birthdate | Nationality
--- | --- | --- | ---
1 | John Smith | 1970-06-18 | USA
2 | Jane Doe | 1983-07-20 | UK
3 | Michael Johnson | 1995-08-30 | Canada

## Films

FilmID | Title | ReleaseDate | Genre
--- | --- | --- | ---
1 | Movie A | 2010-01-01 | Drama
2 | Movie B | 2012-02-02 | Comedy
3 | Movie C | 2014-03-03 | Action

## Directors

DirectorID | Name | Birthdate | Nationality
--- | --- | --- | ---
1 | Alice Brown | 1965-09-15 | Australia
2 | Bob White | 1975-10-20 | Germany

## Assignments

AssignmentID | VisualDesignRole | NumberOfFilmsWorkedOn | DirectorID | FilmID
--- | --- | --- | --- | ---
|  |  | (→ Directors.DirectorID) | (→ Films.FilmID)
1 | Art Director | 25 | 1 | 1
2 | Art Director | 15 | 2 | 2
3 | Set Designer | 25 | 1 | 3
4 | Set Designer | 10 | 2 | 1

## Actors

ActorID | Name | Birthdate | Nationality
--- | --- | --- | ---
1 | Chris Evans | 1981-06-13 | USA
2 | Emma Stone | 1988-11-06 | USA
3 | Robert Downey Jr. | 1965-04-04 | USA

## Roles

RoleID | CharacterName | FilmID
--- | --- | ---
|  | (→ Films.FilmID)
1 | Superhero | 1
2 | Villain | 2
3 | Heroine | 3

## Casting

CastingID | ActorID | RoleID
--- | --- | ---
| (→ Actors.ActorID) | (→ Roles.RoleID)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3