## Blockbusters

id | title | releaseYear | director | budget | boxOffice | film_festival_id
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Festivals.id)
1 | Avatar | 2009 | James Cameron | 237.0 | 2747.0 | 1
2 | Titanic | 1997 | James Cameron | 200.0 | 2202.0 | 2

## Indies

id | title | releaseYear | director | budget | gross | film_festival_id
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Festivals.id)
1 | Little Miss Sunshine | 2006 | Jonathan Dayton | 8.0 | 60.0 | 1
2 | Juno | 2007 | Jason Reitman | 6.0 | 231.0 | 2

## Festivals

id | name
--- | ---
1 | Sundance Film Festival
2 | Cannes Film Festival

## Directors

id | name | birthDate | nationality
--- | --- | --- | ---
1 | Quentin Tarantino | 1963-03-27 | American
2 | Christopher Nolan | 1970-07-30 | English

## Actors

id | name | dateOfBirth | gender | ethnicity
--- | --- | --- | --- | ---
1 | Leonardo DiCaprio | 1974-11-11 | Male | Italian/German/Irish
2 | Jennifer Lawrence | 1990-08-15 | Female | England

## Roles

actor_id | film_id | characterName
--- | --- | ---
(→ Actors.id) | (→ Action_Films.id) |
1 | 1 | Dom Cobb
2 | 1 | Rachel McDougall
1 | 2 | Howard St John
2 | 2 | Harvey Dent

## Action_Films

id | title | releaseYear | genre | runtime | language | film_festival_id
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Festivals.id)
1 | Inception | 2010 | Action/Science Fiction | 148 | English | 1
2 | The Dark Knight | 2008 | Action/Crime | 152 | English | 2