I'm designing a database for a review site.
There are products, and then for each product there can be multiple reviews.
I'm trying to add a subscription system, so that a user can subscribe to reviews and see the new ones when they login to the system.
How would you do it?
Would you do this in relation to the product or the reviewproduct? Also this is a many-to-many, so I would decompose in an associative entity.
Now my biggest doubt, I need to save the new reviews for the products that the user subscribed, how would you do this in the ER?
Thanks for the help, Br, Tiago