Simple survey database design
Generally one row per respondent, and one column per question item.  A battery of ten check-all-that-apply questions would thus get ten columns (either boolean or integer).  Each open end gets a String field.  During analysis, you can get fancy and aggregate questions, stack repeated batteries of questions, etc. in SAS, SPSS or Excel.