Authors

idnamebirthdate
1Author A1970-01-01
2Author B1960-06-30
3Author C1985-02-15
4Author D1990-10-20
5Author E1955-08-12

Books

idtitlegenreyear_of_publicationauthor_id
(→ Authors.id)
1Book AScience Fiction20181
2Book BRomance20192
3Book CMystery20203
4Book DScience Fiction20214
5Book EThriller20225

ScienceFictionBooks

idbook_titlesciencefictionyear_of_publication
(→ Books.year_of_publication)
1SciFi Book A12018
2SciFi Book B02020

RomanceBooks

idbook_titleromanceyear_of_publication
(→ Books.year_of_publication)
1Love Story A12018
2Love Story B02020

Publishers

idpublisher_namecountry
1Publisher XUSA
2Publisher YUK
3Publisher ZCanada

BookPublishers

idbook_titlepublisher_id
(→ Publishers.id)
1Published Book A1
2Published Book B2
3Published Book C3

Awards

idaward_nameawarded_book_id
(→ Books.id)
1Award A1
2Award B2