## SciFiMovies

id | title | director | releaseYear | sciFi | filmingLocation
--- | --- | --- | --- | --- | ---
1 | Star Wars | George Lucas | 1977 | 1 | New Zealand
2 | Blade Runner | Ridley Scott | 1982 | 1 | United States

## FantasyMovies

id | title | director | releaseYear | fantasy | filmingLocation
--- | --- | --- | --- | --- | ---
1 | Lord of The Rings | Peter Jackson | 2001 | 1 | New Zealand
2 | Harry Potter and The Philosopher's Stone | Chris Columbus | 2001 | 1 | United Kingdom

## Actors

id | name | birthDate | nationality
--- | --- | --- | ---
1 | Keanu Reeves | September 2, 1964 | Canada
2 | Natalie Portman | June 9, 1981 | Israel

## Roles

movieId | actorId | roleName
--- | --- | ---
(→ Movies.id) | (→ Actors.id) |
1 | 1 | Neo
3 | 2 | Padmé Amidala

## Directors

id | name | birthDate | nationality
--- | --- | --- | ---
1 | Christopher Nolan | July 30, 1970 | England
2 | Guillermo del Toro | October 9, 1964 | Spain

## Productions

id | movieTitle | productionCompany | budget | startDate | endDate
--- | --- | --- | --- | --- | ---
1 | Inception | Warner Bros. | 160.0 | June 16, 2009 | August 16, 2010
2 | Pan's Labyrinth | Pictaza | 30.0 | April 17, 2005 | December 17, 2005