$1.$ Author

Attributes:

AuthorID $($PK$)$

FirstName

LastName

Relation:

Author$($AuthorID$,$ FirstName, LastName$)$

$2.$ Book

Attributes:

BookID $($PK$)$

Title

AuthorID $($FK referencing Author$($AuthorID$))$

Relation:

Book$($BookID$,$ Title, AuthorID$)$

$3.$ Reviewer

Attributes:

ReviewerID $($PK$)$

FirstName

LastName

Relation:

Reviewer$($ReviewerID$,$ FirstName, LastName$)$

$4.$ Review Report

Attributes:

ReportID $($PK$)$

BookID $($FK referencing Book$($BookID$))$

ReviewerID $($FK referencing Reviewer$($ReviewerID$))$

Rating

ReviewDate

Relation:

ReviewReport$($ReportID$,$ BookID, ReviewerID, Rating, ReviewDate$)$

Relationships & Foreign Keys

Book and Author:

One$-$to$-$Many relationship $($one author can write many books$).$

Foreign Key: Book.AuthorID $->$ Author.AuthorID.

ReviewReport and Book:

Many$-$to$-$One relationship $($many review reports for one book$).$

Foreign Key: ReviewReport.BookID $->$ Book.BookID.

ReviewReport and Reviewer:

Many$-$to$-$One relationship $($many review reports from one reviewer$).$

Foreign Key: ReviewReport.ReviewerID $->$ Reviewer.ReviewerID. draw a GRD for all of this information