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 |