title: Relational Database Design for Customer Reviews
body: <p>Suppose I want to create a database to store customer reviews of a restaurant.</p>
  
  <p>Now suppose I have a database table called 'Qualities' of certain qualities that a restaurant has (e.g. customer service, quality of food, atmosphere, value for money etc. ) along with a more detailed description of each of these qualities.</p>
  
  <p>Now let's say I also have a table called 'Reviews' of individual reviews which assign a rating to each of the aforementioned qualities in the 'Qualities' table.</p>
  
  <p>This poses a dilemma: The number of columns in the 'Reviews' table is dependent on the number of rows on the 'Qualities' table. If we add a new quality to be rated in the 'Qualities' table we need to create a corresponding column in the 'Reviews' table so users can rate this quality.</p>
  
  <p>What would be the best way to design a relational database for the problem above? If you include a database schema with you answer then that could be helpful. </p>
  
  <p>Thanks.</p>