Authors

AuthorIDNameCountry
1John DoeUSA
2Jane SmithUK
3Alice JohnsonCanada
4Bob BrownAustralia
5Charlie WhiteGermany

Books

ISBNTitleYearOfPublicationGenreAuthorID
(→ Authors.AuthorID)
1234567890123Science Fiction Book2018Science Fiction1
9876543210987Another Science Fiction Book2020Science Fiction1
1122334455667Romance Book2018Romance2
665544332211Yet Another Romance Book2019Romance2
778899110000Mystery Book2017Mystery3

Publishers

PublisherIDNameLocation
1Publisher ANew York
2Publisher BLondon
3Publisher CToronto
4Publisher DSydney
5Publisher EBerlin

BookPublishingHistory

PublishingIDISBNPublisherIDYearOfPublication
(→ Books.ISBN)(→ Publishers.PublisherID)
1123456789012312018
2987654321098722020
3112233445566732018
466554433221142019
577889911000052017

SalesData

SaleIDISBNQuantitySoldRevenueDateOfSale
(→ Books.ISBN)
11234567890123500100002021-08-01
29876543210987600120002021-08-02
3112233445566740080002021-08-03
466554433221130060002021-08-04
577889911000020040002021-08-05

Reviews

ReviewIDISBNRatingCommentDatePosted
(→ Books.ISBN)
112345678901235Excellent book!2021-08-01
298765432109874Good read.2021-08-02
311223344556673Average story.2021-08-03
46655443322112Not my cup of tea.2021-08-04
57788991100001Did not like it at all.2021-08-05