## Novels

id | Title | Author | Year | Genre | Character
--- | --- | --- | --- | --- | ---
1 | Book1 | AuthorA | 2000 | Fiction | John Smith
2 | Book2 | AuthorB | 2002 | Mystery | Jane Doe
3 | Book3 | AuthorC | 2004 | Romance | Robert Johnson
4 | Book4 | AuthorD | 2006 | Thriller | Lisa Brown
5 | Book5 | AuthorE | 2008 | Science Fiction | David Miller

## ShortStories

id | Title | Author | Year | Theme | Character
--- | --- | --- | --- | --- | ---
1 | Story1 | AuthorA | 2001 | Adventure | John Smith
2 | Story2 | AuthorB | 2003 | Humor | James White
3 | Story3 | AuthorC | 2005 | Drama | Elizabeth Green
4 | Story4 | AuthorD | 2007 | Tragedy | Tommy Black
5 | Story5 | AuthorE | 2009 | Horror | William Gray

## Authors

id | Name | BirthDate | Nationality | Biography
--- | --- | --- | --- | ---
1 | AuthorA | 1970-01-01 | American | Biography of Author A
2 | AuthorB | 1972-02-02 | English | Biography of Author B
3 | AuthorC | 1974-03-03 | Canadian | Biography of Author C
4 | AuthorD | 1976-04-04 | Australian | Biography of Author D
5 | AuthorE | 1978-05-05 | Irish | Biography of Author E

## Publishers

id | Name | EstablishedYear | Location | NumberOfEmployees
--- | --- | --- | --- | ---
1 | PublisherX | 1980 | New York | 1000
2 | PublisherY | 1990 | London | 2000
3 | PublisherZ | 2000 | Toronto | 3000
4 | PublisherW | 2010 | Dublin | 4000
5 | PublisherV | 2020 | Tokyo | 5000