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