title: uncertainty in developing a database model
body: <p>I'm trying to develop a database model for candidate, their registered exams and result of the exams when its being taken. 
  This is what I've done so far. however im unsure if am on the right track especially from the examination table to the examination result table.
  how easy will it be to right write an insert sql code for examinationresult population for a  particular candidate</p>
  
  <p>the examination types are categorised into science, art and social science. they all have 4 components each</p>
  
  <p><img src="https://i.stack.imgur.com/Ljyim.jpg" alt="enter image description here"></p>