title: Database design for a rating system
body: <p>The application handles users and objects, users rate objects with 3 features (one rate per feature).</p>
  
  <p><strong>EDIT</strong>: the last sentence is unclear : by features I mean criterias shared by all the objects </p>
  
  <p>How efficiently design a database for such a system ?
  What are the best-practices for designing a database dealing with a rating system ?</p>
  
  <p>what I was thinking of:</p>
  
  <p>Tables:</p>
  
  <ul>
  <li>users</li>
  <li>objects</li>
  <li>feat1rates</li>
  <li>feat2rates</li>
  <li>feat3rates</li>
  </ul>
  
  <p>and relationships :
  An object has many</p>
  
  <ul>
  <li>feat1rates</li>
  <li>feat2rates</li>
  <li>feat3rates</li>
  </ul>
  
  <p>A user has many</p>
  
  <ul>
  <li>feat1rates</li>
  <li>feat2rates</li>
  <li>feat3rates</li>
  </ul>