| AuthorID | Name |
|---|---|
| 1 | J.K. Rowling |
| 2 | George Orwell |
| 3 | Harper Lee |
| 4 | Ernest Hemingway |
| 5 | Gabriel Garcia Marquez |
| ReviewerID | FullName | |
|---|---|---|
| 1 | john.doe@example.com | John Doe |
| 2 | jane.smith@example.com | Jane Smith |
| 3 | michael.brown@example.com | Michael Brown |
| 4 | emma.wilson@example.com | Emma Wilson |
| 5 | william.jackson@example.com | William Jackson |
| BookID | Title | ISBN | PublishDate |
|---|---|---|---|
| 1 | Harry Potter and the Philosopher's Stone | 9780747532699 | 1997-06-26 |
| 2 | 1984 | 9780451524935 | 1949-06-08 |
| 3 | To Kill a Mockingbird | 9780060935467 | 1960-07-11 |
| 4 | The Old Man and the Sea | 9780684867644 | 1952-01-01 |
| 5 | One Hundred Years of Solitude | 9780679733401 | 1967-03-02 |
| ReviewID | Rating | Comment | ReviewedOn | BookID |
|---|---|---|---|---|
| (→ Books.BookID) | ||||
| 1 | 5 | Great story! | None | 1 |
| 2 | 4 | Interesting book. | None | 2 |
| 3 | 3 | Good read but could have been better. | None | 3 |
| 4 | 5 | A classic masterpiece. | None | 4 |
| 5 | 4 | Fascinating exploration of human nature. | None | 5 |
| ReviewerID | AuthorID |
|---|---|
| (→ Book_Reviewers.ReviewerID) | (→ Authors.AuthorID) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |