title: MySQL - Multiple choice question - New table to store question category?
body: <p>I am working on a multiple choice question form. I am using Flask on the back-end and MySQL as a database.</p>
  <p>There will be more than 1 end-user. I already made a users table but haven't work on it yet
  There are multiple questions but I only display one question at once.
  Every question have either 3 or 4 possible choices (A, B, C or A, B, C, D)
  There is always one correct answer
  The user can filter question based on category and get stats by category (% of question answered for this category for example)
  Should I create a new table called category which would look like category_id (int, primary_key), category_text (varchar(50))?
  <a href="https://i.stack.imgur.com/WyDWp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WyDWp.png" alt="MySQL )" /></a></p>