## Film

id | title | releaseDate | duration | animationStudio | awards
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Studio.name) |
1 | Toy Story | 1995-03-26 | 82 | Pixar | Golden Globe
2 | Finding Nemo | 2003-07-06 | 100 | Pixar | Oscar
3 | Shrek | 2001-04-18 | 88 | DreamWorks | Golden Globe
4 | Madagascar | 2005-05-04 | 89 | DreamWorks | Nickelodeon Kids Choice Award

## Director

id | name | birthYear
--- | --- | ---
1 | John Lasseter | 1957
2 | Andrew Stanton | 1961
3 | Adam Foucher | 1970
4 | Chris Buck | 1960
5 | Erik de la Espriella | 1970

## Actor

id | name | birthYear
--- | --- | ---
1 | Tom Hanks | 1954
2 | Tim Allen | 1953
3 | David Hyde Pierce | 1951
4 | Ian Holm | 1931
5 | Billy Crystal | 1941

## Genre

id | genreName
--- | ---
1 | Animated Comedy
2 | Family Adventure
3 | Action/Adventure
4 | Drama
5 | Mystery

## FilmActors

filmID | actorID | role
--- | --- | ---
(→ Film.id) | (→ Actor.id) |
1 | 1 | Woody
1 | 2 | Buzz Lightyear
2 | 3 | Marlin
2 | 4 | Dory
3 | 5 | Donkey