title: Is this Normalised Multiple Choice Quiz Program Database Design OK?
body: <p>I am designing a simple multiple choice quiz program in python where the user signs in and takes a multiple choice quiz of 5 questions (selected randomly from a table of questions) and the program ends the quiz with a display of their questions, their answers, the correct answers and their score.</p>
  
  <p>Is the following database design correct? I have three tables, one for the student, one of the questions (options and answer) and one for the quizzes taken.</p>
  
  <p>The real question I suppose is whether or not it is OK to have the same foreign key (questionsID) inserted into the quiz table on 5 separate occasions?</p>
  
  <p><img src="https://i.stack.imgur.com/Vhv2I.png" alt="enter image description here"></p>