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) | (→ Films.id) | |
1 | 1 | Dom Cobb |
2 | 1 | Rachel McDougall |
1 | 2 | Howard St John |
2 | 2 | Harvey Dent |
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 |