title: Database design for a quiz app
body: <p>I am little stuck with the database design for my quiz app. Kindly guide me on this -</p>
  
  <p>My app UI will go something like this -</p>
  
  <p><img src="https://i.stack.imgur.com/qhsOz.jpg" alt="Image"></p>
  
  <p>My <code>DB</code> Tables - </p>
  
  <p><strong>User</strong> -</p>
  
  <pre><code>user_id
  user_name
  user_email
  user_password
  user_registration_date
  user_active
  </code></pre>
  
  <p><strong>Question</strong> -</p>
  
  <pre><code>question_id
  question_title
  question_category_id
  question_level_id
  question_author_id
  question_status
  question_create_date
  </code></pre>
  
  <p><strong>Category</strong> -</p>
  
  <pre><code>cat_id
  cat_name
  cat_author
  cat_create-date
  cat_status
  </code></pre>
  
  <p><strong>Level</strong> -</p>
  
  <pre><code>level_id
  level_name
  </code></pre>
  
  <p><strong>Answer</strong> -</p>
  
  <pre><code>?????????
  </code></pre>
  
  <p><strong>Queries</strong> - </p>
  
  <p>I am stuck with the answer table..means I am not sure what columns to be set in answer table with the <code>data type</code> for this.</p>
  
  <p>MY answer will only going to be in option format means 1,2,3,4 options or true false in an option  NO text type answer ..just a choice selection.</p>
  
  <p>Kindly guide me as I am stuck with this.</p>
  
  <p>Please signify if there is something wrong in the above mentioned tables as well and let me know if crating a separate table for Level is <code>OK</code> or its a bad (Level will only be - Beginner, Intermediate, Advance).</p>