| BookID | Title | Author | PublicationYear | Summary | Themes | Novel |
|---|---|---|---|---|---|---|
| 1 | Pride and Prejudice | Jane Austen | 1797 | The story follows Elizabeth Bennet as she deals with issues of marriage, morality, education... | Love, Marriage | 1 |
| 2 | 1984 | George Orwell | 1949 | In a dystopian future... | Politics, Totalitarianism | 0 |
| 3 | Crime and Punishment | Fyodor Dostoevsky | 1866 | A psychological thriller that delves into the mind of Raskolnikov... | Psychology, Crime | 0 |
| 4 | Adventures of Huckleberry Finn | Mark Twain | 1884 | Set against the backdrop of slavery in mid-19th century America... | Race Relations, Adventure | 0 |
| 5 | Hamlet | William Shakespeare | 1603 | Prince Hamlet seeks revenge on his uncle... | Tragedy, Revenge | 1 |
| AuthorID | FirstName | LastName | BirthDate | DeathDate | Biography |
|---|---|---|---|---|---|
| 1 | Jane | Austen | 1775-04-16 | None | Jane Austen was an English novelist known primarily for her six major novels... |
| 2 | George | Orwell | 1903-06-25 | 1950-01-21 | George Orwell was a British writer and journalist... |
| 3 | Fyodor | Dostoevsky | 1821-11-11 | 1881-02-09 | Fyodor Dostoevsky was a Russian author... |
| 4 | Mark | Twain | 1835-11-30 | 1910-04-21 | Samuel Langhorne Clemens, better known by his pen name Mark Twain... |
| 5 | William | Shakespeare | 1564-04-26 | 1616-04-23 | William Shakespeare was an English poet, playwright... |
| PublisherID | Name | Address | PhoneNumber |
|---|---|---|---|
| 1 | Penguin Random House | New York City | +1-212-366-2000 |
| 2 | HarperCollins | New York City | +1-212-207-7000 |
| 3 | Hachette Book Group | New York City | +1-212-364-1000 |
| 4 | Simon & Schuster | New York City | +1-212-698-7000 |
| 5 | Macmillan Publishing | New York City | +1-212-339-6000 |
| GenreID | Name |
|---|---|
| 1 | Romance |
| 2 | Mystery |
| 3 | Historical Fiction |
| 4 | Science Fiction |
| 5 | Thriller |