cutebaby20bk
New Member
Im a beginner in database design, so i wanna ask before im laughed at after showing a 100-column table..<br />
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.<br />
<br />
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.<br />
<br />
Is this properly normalized?<br />
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.<br />
<br />
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.<br />
<br />
Is this properly normalized?<br />