5 Replies Latest reply: Jun 3, 2013 5:40 AM by MurraySummers RSS

    Database structure for a 5 star ratings system

    johngordon12 Community Member

      This is something I've been asked to look at creating. At the moment the site has a database back end storing details of a few hundred holiday properties. So that part is already set up.


      So I'm familiar enough with databases etc, but less so the formulas and any additional database structure for any voting.


      It would be pretty simple, ie visitors could vote 1, 2, 3 4, or 5 stars for any property.


      There needs to be a total score recorded somewhere for each property.


      And the site needs to display the average score for that property.


      Any pointers on this much would be much appreciated.