id | Title | ReleaseYear | Genre | AdaptationOf | WrittenBy |
---|---|---|---|---|---|
(→ OriginalWorks.Title) | |||||
1 | Carrie | 2002 | Horror | Carrie | Stephen King |
2 | Game of Thrones | 2011 | TV Series | A Game of Thrones | David Benioff & D.B. Weiss |
3 | Brideshead Revisited | 2008 | Drama | Pride and Prejudice | Charles Bryant & Jeannie Deutsch |
4 | Heart of Darkness | 1993 | Drama | Things Fall Apart | Francis Ford Coppola |
5 | Love in the Time of Cholera | 2007 | Drama | One Hundred Years of Solitude | Jeffrey Hirschfield |
id | Title | ReleaseYear | Genre | WrittenBy |
---|---|---|---|---|
(→ Authors.Name) | ||||
1 | Carrie | 1974 | Horror | Stephen King |
2 | A Game of Thrones | 1996 | Fantasy | George R.R. Martin |
3 | Pride and Prejudice | 1813 | Romance | Jane Austen |
4 | Things Fall Apart | 1958 | Drama | Chinua Achebe |
5 | One Hundred Years of Solitude | 1967 | Magical Realism | Gabriel Garcia Marquez |
Name | BirthDate | DeathDate | Nationality |
---|---|---|---|
Stephen King | 1947-09-21 | 20XX-XX-XX | American |
George R.R. Martin | 1948-09-20 | 20XX-XX-XX | American |
Jane Austen | 1775-16-16 | 1817-07-18 | English |
Chinua Achebe | 1930-11-16 | 2013-03-21 | Nigerian |
Gabriel Garcia Marquez | 1928-06-06 | 2014-04-17 | Colombian |
id | Name | BirthDate | DeathDate | Nationality |
---|---|---|---|---|
1 | Christopher Nolan | 1970-07-30 | 20XX-XX-XX | English |
2 | Martin Scorsese | 1942-11-22 | 20XX-XX-XX | American |
3 | Guillermo del Toro | 1964-03-09 | 20XX-XX-XX | Mexican |
4 | Ang Lee | 1954-11-23 | 20XX-XX-XX | Taiwanese-American |
5 | Peter Jackson | 1961-10-31 | 20XX-XX-XX | New Zealand |
id | Name | DateOfBirth | PlaceOfBirth |
---|---|---|---|
1 | Leonardo DiCaprio | 1974-11-11 | Los Angeles, California, U.S. |
2 | Kate Winslet | 1975-10-05 | Reading, Berkshire, England |
3 | Tom Hanks | 1956-07-09 | Concord, California, U.S. |
4 | Denzel Washington | 1954-12-28 | Mount Vernon, New York, U.S. |
5 | Scarlett Johansson | 1984-11-22 | New York City, New York, U.S. |
filmID | actorID | role |
---|---|---|
(→ Films.id) | (→ Actors.id) | |
1 | 1 | Cobb |
1 | 2 | Arthur |
2 | 3 | Colonel Williams |
2 | 4 | Madam Gao |
3 | 5 | Sméagol |
3 | 6 | Gollum |
4 | 7 | Pi |
4 | 8 | Richard Parker |
5 | 9 | Frodo Baggins |
5 | 10 | Samwise Gamgee |
id | Title | ReleaseYear | Genre | DirectorId |
---|---|---|---|---|
(→ Directors.id) | ||||
1 | Inception | 2010 | Action/Science Fiction | 1 |
2 | The Departed | 2006 | Crime/Thriller | 2 |
3 | Pan's Labyrinth | 2006 | Fantasy/Drama | 3 |
4 | Life of Pi | 2012 | Adventure/Drama | 4 |
5 | The Lord of the Rings: The Fellowship of the Ring | 2001 | Adventure/Fantasy | 5 |
filmID | directorID | cinematographer | editor | composer |
---|---|---|---|---|
(→ Films.id) | (→ Directors.id) | |||
1 | 1 | Wally Pfister | Lee Smith | Hans Zimmer |
2 | 2 | Roger Deakins | William Goldenberg | Howard Shore |
3 | 3 | Guillermo Navarro | Javier Otegui | Javier Navarrete |
4 | 4 | Claudio Miranda | Daniel Rebert | Alexandre Desplat |
5 | 5 | Andrew Lesnie | John Williams | Howard Shore |