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