## Adaptations

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

## OriginalWorks

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

## Authors

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

## Directors

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

## Actors

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.

## FilmCast

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

## Films

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

## FilmCrew

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