Database structure question.
I’ve already got this sorted but I just want to check that there isn’t a
If I have 5 fixed ratings per review as columns in the table of reviews
and then 5 fixed ratings (an average of all the reviews) as columns in
the table of restaurants, is this alright?
Or should I make a separate ratings table with 5 fields. In my mind
there is little point making a separate table for ratings if there would
only ever at most be one row belonging to a review. However it would
mean less columns in the reviews and restaurants tables. Thoughts?