Rating System Database Structure

Posted by Harsha M V on Stack Overflow See other posts from Stack Overflow or by Harsha M V
Published on 2010-06-01T05:51:41Z Indexed on 2010/06/01 5:53 UTC
Read the original article Hit count: 319

Filed under:

database-connection

|

relational-database

|

rating

|

rating-system

I have two entity groups. Restaurants and Users. Restaurants can be rated (1-5) by users. And rating fromeach user should be retrievable.

Resturant(id, name, ..... , total_number_of_votes, total_voting_points ) User (id, name ...... )

Rating (id, restaurant_id, user_id, rating_value)

Do i need to store the avg value so that it need not be calculated every time ? which table is the best place to store avg_rating, total_no_of_votes, total_voting_points ?

© Stack Overflow or respective owner

Related posts about database-connection

Why are there connections open to my databases?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a program that stores user projects as databases. Naturally, the program should allow the user to create and delete the databases as they need to. When the program boots up, it looks for all the databases in a specific SQLServer instance that have the structure the program is expecting. … >>> More
slow Database connection

as seen on Stack Overflow - Search for 'Stack Overflow'
i am working with Windows Applications in c# with MySQL database using wamp server. i have very slow connection when executing the project.what is problem in it and how can i solve this? >>> More
PHP forking and mysql database connection problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I am now trying to do forking in php. I would like to do some query and update in child process.. the problem is that whenever a child process finish, it close the connection which makes the other queries fail. The following is my sample code!! #!/usr/local/bin/php <?php set_time_limit(0); # forever… >>> More
sql database connection on remote server

as seen on Stack Overflow - Search for 'Stack Overflow'
i create my web site on asp.net and i create database in sql using inbuilt it in visual studio i use step to create database 1.right click on solution explorer then add newSqldatabase then ok then if i connect it by coding then it will work on my local PC but actuall i am making website so i want… >>> More
PHP: Proper way of using a PDO database connection in a class

as seen on Stack Overflow - Search for 'Stack Overflow'
Trying to organize all my code into classes, and I can't get the database queries to work inside a class. I tested it without the class wrapper, and it worked fine. Inside the class = no dice. What about my classes is messing this up? class ac { public function dbConnect() { global $dbcon; … >>> More

Related posts about relational-database

Big Data – Buzz Words: Importance of Relational Database in Big Data World – Day 9 of 21

as seen on SQL Authority - Search for 'SQL Authority'
In yesterday’s blog post we learned what is HDFS. In this article we will take a quick look at the importance of the Relational Database in Big Data world. A Big Question? Here are a few questions I often received since the beginning of the Big Data Series - Does the relational database have… >>> More
SQL SERVER – Enumerations in Relational Database – Best Practice

as seen on SQL Authority - Search for 'SQL Authority'
Marko Parkkola This article has been submitted by Marko Parkkola, Data systems designer at Saarionen Oy, Finland. Marko is excellent developer and always thinking at next level. You can read his earlier comment which created very interesting discussion here: SQL SERVER- IF EXISTS(Select null from… >>> More
SQL SERVER Enumerations in Relational Database Best Practice

as seen on Dot net Slackers - Search for 'Dot net Slackers'
This article has been submitted by Marko Parkkola, Data systems designer at Saarionen Oy, Finland. Marko is excellent developer and always thinking at next level. You can read his earlier comment which created very interesting discussion here: SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select… >>> More
Details of 5GB and 50GB SQL Azure databases have now been released, along with new price points

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Like many others signed up to the Windows Azure Platform, I received an email overnight detailing the upcoming database size changes for SQL Azure. I know from our work with early adopters over the last 12 months that the 1GB and 10GB limits were sometimes seen as blockers, especially when migrating… >>> More
Are document-oriented databases meant to replace relational databases?

as seen on Stack Overflow - Search for 'Stack Overflow'
Recently I've been working a little with MongoDB and I have to say I really like it. However it is a completely different type of database then I am used. I've noticed that it is most definitely better for certain types of data, however for heavily normalized databases it might not be the best choice… >>> More