title: How should I organize this(simple polling system) in my relational database?
body: <p>My goal is a simple polling system where users can create a poll question, provide the poll with a set of options(answers) and vote on each poll. I'll provide a simple set of fields I need to collect. Then, I'll provide my solution. Could you tell me if my solution is acceptable?<br />
  <br />
  Fields required: questionText, date, (poster)userId, options(answers), response, (responder)userID, responseDate<br />
  <br />
  <br />
  My curent solution: <br />
  <br /></p>
  
  <pre><code>Table: Polls
  Fields: questionID, questionText, date, userID
  
  Table: Options
  Fields: optionID, optionText, questionID
  
  Table: Respnoses
  Fields: responseID, optionID, userID, responseDate
  </code></pre>
  
  <p><br />
  So to find if a user has responded to a specific poll, I would have to query like this:<br />
  <br /></p>
  
  <pre><code>SELECT responseID FROM Responses
  WHERE userID = [user's id] AND optionID IN(
  Select optionID FROM Options
  WHERE questionID = [specific questionID])
  </code></pre>
  
  <p><br />
  Does that query make sense too? <br />
  Thanks in advance. </p>