Combine your three product tables together into one table, if you don't then you are going to need to create three reviews table. because if some one does a review for "intel c2d e6600" which as an id of 1 and "adobe cs3" which also has an idea of one then which of the two does the review go with. i would make one large table with all of the information need for three product types. that way if will be easy on you when you are asked to do search for different products. microsoft doesn't only make software they also make some hardware. with the chat subject, are you talking about a forum instead of chat. chat will be hard to for a class project. the idea you have for user is about right, i would add a couple more fields like first name, last name, email and maybe some of the im services(aim, yahoo, msn).