## Genres

ID | Name
--- | ---
1 | Action
2 | Drama
3 | Fantasy
4 | Comedy
5 | Horror

## Films

FilmID | Title | Release_Year | GENRE_ID
--- | --- | --- | ---
|  |  | (→ Genres.ID)
1 | Inception | 2010 | 1
2 | The Irishman | 2019 | 3
3 | Harry Potter and the Deathly Hallows Part 2 | 2011 | 4
4 | Jumanji: Welcome to the Jungle | 2017 | 2
5 | Get Out | 2017 | 5

## Novels

NovelID | Title | Author | Publish_Year
--- | --- | --- | ---
1 | To Kill a Mockingbird | Harper Lee | 1960
2 | Pride and Prejudice | Jane Austen | 1813
3 | 1984 | George Orwell | 1949
4 | A Tale of Two Cities | Charles Dickens | 1859
5 | Brave New World | Aldous Huxley | 1932

## Authors

AUTHOR_ID | FullName
--- | ---
1 | Harper Lee
2 | Jane Austen
3 | George Orwell
4 | Charles Dickens
5 | Aldous Huxley

## Adaptations

ADAPTATION_ID | FILM_ID | NOVEL_ID | YEAR
--- | --- | --- | ---
| (→ Films.FilmID) | (→ Novels.NovelID) |
1 | 1 | 1 | 2010
2 | 2 | 3 | 2017
3 | 3 | 2 | 2012
4 | 4 | 1 | 2015
5 | 5 | 4 | 2018