Novels

idTitleAuthorYearGenreCharacter
1Book1AuthorA2000FictionJohn Smith
2Book2AuthorB2002MysteryJane Doe
3Book3AuthorC2004RomanceRobert Johnson
4Book4AuthorD2006ThrillerLisa Brown
5Book5AuthorE2008Science FictionDavid Miller

ShortStories

idTitleAuthorYearThemeCharacter
1Story1AuthorA2001AdventureJohn Smith
2Story2AuthorB2003HumorJames White
3Story3AuthorC2005DramaElizabeth Green
4Story4AuthorD2007TragedyTommy Black
5Story5AuthorE2009HorrorWilliam Gray

Authors

idNameBirthDateNationalityBiography
1AuthorA1970-01-01AmericanBiography of Author A
2AuthorB1972-02-02EnglishBiography of Author B
3AuthorC1974-03-03CanadianBiography of Author C
4AuthorD1976-04-04AustralianBiography of Author D
5AuthorE1978-05-05IrishBiography of Author E

Publishers

idNameEstablishedYearLocationNumberOfEmployees
1PublisherX1980New York1000
2PublisherY1990London2000
3PublisherZ2000Toronto3000
4PublisherW2010Dublin4000
5PublisherV2020Tokyo5000