In Biblico publishing company, a reviewer reviews several books and a book is reviewed by several...

Transcribed Image Text:

In Biblico publishing company, a reviewer reviews several books and a book is reviewed by several reviewers. Given below is a schema for table Review where each row contains information about a reviewer (reviewerld, reviewer Name and reviewerPhone), information of the reviewed Book (ISBN, title and author), the date reviewed and reviewer Comments. Review (reviewerld, reviewerName, reviewerPhone, ISBN, title, author, dateReviewed, reviewerComments) a) What are the problems that result from the above schema? Clearly specify the problems on updating and deleting records from this table. Please refer to the problem given and not a general discussion. b) Identify and list the FDs that you can get from the description. c) Identify a candidate key(s) for the relation Review. In Biblico publishing company, a reviewer reviews several books and a book is reviewed by several reviewers. Given below is a schema for table Review where each row contains information about a reviewer (reviewerld, reviewer Name and reviewerPhone), information of the reviewed Book (ISBN, title and author), the date reviewed and reviewer Comments. Review (reviewerld, reviewerName, reviewerPhone, ISBN, title, author, dateReviewed, reviewerComments) a) What are the problems that result from the above schema? Clearly specify the problems on updating and deleting records from this table. Please refer to the problem given and not a general discussion. b) Identify and list the FDs that you can get from the description. c) Identify a candidate key(s) for the relation Review.