Authors

AuthorIDName
1J.K. Rowling
2George Orwell
3Harper Lee
4Ernest Hemingway
5Gabriel Garcia Marquez

Book_Reviewers

ReviewerIDEmailFullName
1john.doe@example.comJohn Doe
2jane.smith@example.comJane Smith
3michael.brown@example.comMichael Brown
4emma.wilson@example.comEmma Wilson
5william.jackson@example.comWilliam Jackson

Books

BookIDTitleISBNPublishDate
1Harry Potter and the Philosopher's Stone97807475326991997-06-26
2198497804515249351949-06-08
3To Kill a Mockingbird97800609354671960-07-11
4The Old Man and the Sea97806848676441952-01-01
5One Hundred Years of Solitude97806797334011967-03-02

Reviews

ReviewIDRatingCommentReviewedOnBookID
(→ Books.BookID)
15Great story!None1
24Interesting book.None2
33Good read but could have been better.None3
45A classic masterpiece.None4
54Fascinating exploration of human nature.None5

Book_Reviewers_Authors

ReviewerIDAuthorID
(→ Book_Reviewers.ReviewerID)(→ Authors.AuthorID)
11
22
33
44
55