title: What is the best database design for storing multiple subjects?
body: <p>Recently I'm working on a project, in which I need save multiples subjects in my database, and numbers of subject will be change as per student's class. e.g: class "VII" has 6 subject (included 1 option subject), class "VIII" has 8 subjects (1 included option subject) and so on. Even the option subject can be different according to student's choice.</p>
  
  <p>I'm using CheckedListBox control. Here is a screenshot.</p>
  
  <p><img src="https://i.stack.imgur.com/pnVKY.png" alt="enter image description here"></p>
  
  <p>I'm using MS Sql Server 2012. I'm facing difficulty to design database table. I can't understand should i create all the subject columns in my student table or ????(best way). Please help me, thanks in advance.</p>