title: database design table with a lot columns
body: <p>I have a survey to do. 30 more yes/no questions(has 4 types A,B,C,D). if answer is no, user should give reason. I am thinking create a table which has 30 more column for the answer, the column name are like 
  <code>A1,A2...A7,B1,B2,...C1,C2...D1,D2...D8.</code> </p>
  
  <p>Their datatype is bit. And I create another table just for comments with 1:1 relation. Column name like </p>
  
  <pre><code>'A1Cm,A2Cm,...A7Cm,B1Cm.....D8Cm'
  </code></pre>
  
  <p>I don't think it is a good design. But it is the easiest way to load to data to asp.net page.
  Any suggestion?</p>