Authors
| id | name | birthdate |
| 1 | Author A | 1970-01-01 |
| 2 | Author B | 1960-06-30 |
| 3 | Author C | 1985-02-15 |
| 4 | Author D | 1990-10-20 |
| 5 | Author E | 1955-08-12 |
Books
| id | title | genre | year_of_publication | author_id |
| | | | (→ Authors.id) |
| 1 | Book A | Science Fiction | 2018 | 1 |
| 2 | Book B | Romance | 2019 | 2 |
| 3 | Book C | Mystery | 2020 | 3 |
| 4 | Book D | Science Fiction | 2021 | 4 |
| 5 | Book E | Thriller | 2022 | 5 |
ScienceFictionBooks
| id | book_title | sciencefiction | year_of_publication |
| | | (→ Books.year_of_publication) |
| 1 | SciFi Book A | 1 | 2018 |
| 2 | SciFi Book B | 0 | 2020 |
RomanceBooks
| id | book_title | romance | year_of_publication |
| | | (→ Books.year_of_publication) |
| 1 | Love Story A | 1 | 2018 |
| 2 | Love Story B | 0 | 2020 |
Publishers
| id | publisher_name | country |
| 1 | Publisher X | USA |
| 2 | Publisher Y | UK |
| 3 | Publisher Z | Canada |
BookPublishers
| id | book_title | publisher_id |
| | (→ Publishers.id) |
| 1 | Published Book A | 1 |
| 2 | Published Book B | 2 |
| 3 | Published Book C | 3 |
Awards
| id | award_name | awarded_book_id |
| | (→ Books.id) |
| 1 | Award A | 1 |
| 2 | Award B | 2 |