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