title: Need a suggestion on building a DB in mysql
body: <p>I have a problem on building my db, that is I would like to create a DB for the following scenerio. </p>
  
  <p>I have a group of people lets take 5 with one one admin. I have given a questions to the group Like how do you rate your self. and at same rate the others in your group. So each person in a group will rate himself and others and admin will rate for all the people so How I can draw the table. Please provide me your valuable suggestions. </p>
  
  <p>What I have tried is I have created a table as below
  This is table for one student(stud1) he will or himself and for others.</p>
  
  <pre><code>Stud1
  
  Name  Q1 Q2 Q3
  stud1 20 30 40
  stud2 40 50 60 
  </code></pre>
  
  <p>This is the table for another student(stud2)</p>
  
  <pre><code>    Stud2
  
      Name  Q1 Q2 Q3
      stud1 30 10 90
      stud2 80 100 35
  </code></pre>
  
  <p>Like the above table I  will for all the 6 students and for all the 8 questions.
  Now from the table I will take avg of q1 or stud1 (20+30) (the values 20 from table one and  30 from table which is answered for student one or q1 and display a graph lets avg be 25 and what he rated himself that is 20. So by taking two values avg-25 and his own rating 30 I will display the graph.</p>
  
  <p>The values I will post only the values from my android app.</p>