Is it normal to have like 100 columns in a table for a database in MSSQL?
Im a beginner in database design, so i wanna ask before im laughed at after showing a 100-column table..
Im doing a survey project. That table would be the one that my responses are collected. Eg, i have Question 5, a rating type question that goes from Very Important to Not at all Important, then Q5 is divided into 5 areas. And i have 15-20 questions like that, and that would be 15 * 5 questions.
My initial plan was to out a question as a column, so column names would be something like Q5a, Q5b, Q5c, each column contain one response.
Is this properly normalized?
Does anyone have a better idea of how should i store my responses?