I am a newbie when it comes to database design. I was trying to create a blogging application and I ran into a problem. My database consists of the following tables:
HasInt (Records which user has which interest)
Interest (category of blogs: Sports, Literature etc)
Follow (Records which user follows which user)
From what I realise, I should not have anything to do with knowing how many comments have been made for any particular Interest. But I can see that there is a
many to one relationship between Comment and Interest. Should I still record this information ?
If so, why ?