AuthorID | Name | Country |
---|---|---|
1 | John Doe | USA |
2 | Jane Smith | UK |
3 | Alice Johnson | Canada |
4 | Bob Brown | Australia |
5 | Charlie White | Germany |
ISBN | Title | YearOfPublication | Genre | AuthorID |
---|---|---|---|---|
(→ Authors.AuthorID) | ||||
1234567890123 | Science Fiction Book | 2018 | Science Fiction | 1 |
9876543210987 | Another Science Fiction Book | 2020 | Science Fiction | 1 |
1122334455667 | Romance Book | 2018 | Romance | 2 |
665544332211 | Yet Another Romance Book | 2019 | Romance | 2 |
778899110000 | Mystery Book | 2017 | Mystery | 3 |
PublisherID | Name | Location |
---|---|---|
1 | Publisher A | New York |
2 | Publisher B | London |
3 | Publisher C | Toronto |
4 | Publisher D | Sydney |
5 | Publisher E | Berlin |
PublishingID | ISBN | PublisherID | YearOfPublication |
---|---|---|---|
(→ Books.ISBN) | (→ Publishers.PublisherID) | ||
1 | 1234567890123 | 1 | 2018 |
2 | 9876543210987 | 2 | 2020 |
3 | 1122334455667 | 3 | 2018 |
4 | 665544332211 | 4 | 2019 |
5 | 778899110000 | 5 | 2017 |
SaleID | ISBN | QuantitySold | Revenue | DateOfSale |
---|---|---|---|---|
(→ Books.ISBN) | ||||
1 | 1234567890123 | 500 | 10000 | 2021-08-01 |
2 | 9876543210987 | 600 | 12000 | 2021-08-02 |
3 | 1122334455667 | 400 | 8000 | 2021-08-03 |
4 | 665544332211 | 300 | 6000 | 2021-08-04 |
5 | 778899110000 | 200 | 4000 | 2021-08-05 |
ReviewID | ISBN | Rating | Comment | DatePosted |
---|---|---|---|---|
(→ Books.ISBN) | ||||
1 | 1234567890123 | 5 | Excellent book! | 2021-08-01 |
2 | 9876543210987 | 4 | Good read. | 2021-08-02 |
3 | 1122334455667 | 3 | Average story. | 2021-08-03 |
4 | 665544332211 | 2 | Not my cup of tea. | 2021-08-04 |
5 | 778899110000 | 1 | Did not like it at all. | 2021-08-05 |