## Authors

AuthorID | Name | BirthDate | Country
--- | --- | --- | ---
1 | Jane Doe | 1976-03-01 | USA
2 | John Smith | 1990-06-05 | Canada
3 | Michael Johnson | 1985-12-15 | UK
4 | Emily Davis | 1995-08-10 | Australia
5 | David Brown | 1980-01-05 | New Zealand

## Publishers

PublisherID | Name | Address | YearEstablished
--- | --- | --- | ---
1 | Random House | NYC, USA | 1927
2 | HarperCollins | London, UK | 1919
3 | Simon & Schuster | NYC, USA | 1924
4 | Hachette Book Group | Paris, France | 1942
5 | Macmillan Publishers | London, UK | 1843

## Genres

GenreID | Description
--- | ---
1 | Science fiction books focus on imaginary elements such as futuristic science advanced technology.
2 | Fantasy genre consists of works based on myths and legends.
3 | Horror genre involves suspense and horror elements like ghosts and supernatural events.
4 | Thriller genre revolves around fast pacing plot filled with unexpected twists.
5 | Non-fiction genre deals with real life facts, events or people.

## Books

BookID | Title | PageCount | Book_Genre | Year_Of_Publication | AuthorID | PublisherID | GenreID
--- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Authors.AuthorID) | (→ Publishers.PublisherID) | (→ Genres.GenreID)
1 | The Science of Tomorrow | 320 | Science Fiction Book | 2018 | 1 | 2 | 1
2 | Love Beyond Time | 280 | Romance Book | 2018 | 2 | 3 | 2
3 | Into The Stars | 350 | Science Fiction Book | 2021 | 3 | 1 | 1
4 | A Love Unforgettable | 300 | Romance Book | 2020 | 4 | 4 | 2
5 | Mythical Creatures | 250 | Fantasy Book | 2017 | 5 | 5 | 3
6 | The Haunting Shadows | 260 | Horror Book | 2019 | 6 | 2 | 4
7 | The Art Of Deception | 270 | Thriller Book | 2020 | 7 | 4 | 5
8 | History In Black And White | 310 | Non-Fiction Book | 2017 | 8 | 3 | 6
9 | The Alien Encounter | 290 | Science Fiction Book | 2021 | 9 | 5 | 1
10 | An Eternal Promise | 285 | Romance Book | 2018 | 10 | 1 | 2