Question 2: Use this form and common business rules to answer the question. The form is for recording customer reviews.

Item Reviews

ItemID, Description, Category, Price

Reviews

Date/time, Comment, Rating, Reviewer Screen Name, Date started

Which of the following tables is in third normal form? (primary keys are underlined)

1. *ItemID, Description, *DateTime, Comment, Rating
2. *ItemID, *ReviewerID, ScreenName, Rating
3. *ItemID, Description, Category, Price, Rating
4. *ItemID, *DateTime, ReviewerID, Comment, Rating
5. *ReviewerID, *DateTime, Comment, Rating

Question 3: Using the Item Reviews form in question 2, which of the following relationships is accurate?

1. Item : Reviewer 1 : M
2. Item : Comment 1 : M
3. Item : Comment M : N
4. Reviewer : Comment M : N
5. Reviewer : Comment 1 : 1