I'm hoping someone can help me. I've tried again and again and I can't seem to get this right. I want to construct the following database. I've tried several ways in which to use a join table to no avail. I believe it needs to be a many to many database. I think there would need to be 3 individual tables (reviewers, movies, and reviews).
I want have one where multiple different reviewers can write various reviews including more than one on an individual movie on different movies. Thus one movies can have multiple reviews by one reviewer and other different reviewers. One reviewer can review multiple different movies including more than one review on an individual movie. Any one review could only be by one reviewer on one movie. On top of that I would like for a reviewer to be able to rate the movies 1-10 and then have each movie be able to have a calculated average score.