I would like to know how the following points are generally addressed with forums, for example this forum.
1. Primary Key / Unique for message titles and forum titles.
Is it ideal to have the forum title as key or ID with forum title being UNIQUE. Also wouldn't each message have the same constraint.
2. I have seen this done in this and other forums the concept of user's rating's changing depending on their post title. Would this be handled on the DBMS or app.If DBMS i dont think a trigger would be used due to being very inefficent for every message posted etc.
Bessie Braddock: Winston, you are drunk!
Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.