## PixarMovies

id | title | release_year | director | box_office
--- | --- | --- | --- | ---
1 | Toy Story | 2019 | Josh Cooley | 3876123.0
2 | Finding Nemo | 2003 | Andrew Stanton | 9400480.0
3 | Inside Out | 2015 | Pete Docter | 8570000.0
4 | Coco | 2017 | Lee Unkrich | 8070000.0
5 | Monsters Inc. | 2001 | Peter Docter | 5650000.0

## Awards

award_id | award_name | year_awarded
--- | --- | ---
1 | Best Animated Feature Film | 2010
2 | Best Original Screenplay | 2004
3 | Best Animated Feature Film | 2016
4 | Best Picture | 2010
5 | Best Animated Feature Film | 2018

## PixarWins

movie_id | award_id
--- | ---
(→ PixarMovies.id) | (→ Awards.award_id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## DreamWorksMovies

id | title | release_year | director | box_office
--- | --- | --- | --- | ---
1 | Shrek | 2001 | Andrew Adamson | 4270000.0
2 | Madagascar | 2005 | Eric Darnell | 7910000.0
3 | Kung Fu Panda | 2008 | Mark Osborne | 6320000.0
4 | How To Train Your Dragon | 2010 | Dean DeBlois | 4940000.0
5 | Boss Baby | 2017 | Tom McGrath | 5400000.0

## DreamWorksWins

movie_id | award_id
--- | ---
(→ DreamWorksMovies.id) | (→ Awards.award_id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## Actors

actor_id | name
--- | ---
1 | Tom Hanks
2 | Tim Allen
3 | John Goodman
4 | Nick Park
5 | Randy Newman

## MovieCast

movie_id | actor_id | character_played
--- | --- | ---
(→ DreamWorksMovies.id) | (→ Actors.actor_id) |
1 | 1 | Woody
1 | 2 | Buzz Lightyear
2 | 3 | Alex the Lion
2 | 4 | Hiccup Horrendous Haddock III
3 | 5 | Dragon Fang