Growing Tables Horizontally by the Additon of Columns
I am working on a survey app for a CEO (who has a degree Computer Engineering). For the part where re record the results, he is insisting that I simply add more columns to database every time someone ads more questions.
form1, question_answer1, quesitonanswer2, questionanswer3, ....questionanswer50, questionanswer51 etc.
I couldn't even respond with words as I cringed and wanted to throw up mere suggestion.
This goes against every principle of RDBMS design I have been taught.
How do I tell him he is wrong without coming across as a jerk?