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 |
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 |
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. |
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 |