I'm a bit confused about how I need to store the answers to a multiple question type of exercise coming from an app I'm trying to create.
I have 2 tables pertaining to this:
"Question" and "Answer"
In Question, I have the following general structure:
• id BIGINT(20) NOT_NULL AUTO_INC
• q_question TEXT NOT_NULL
In Answer, I have the following general structure:
• id (QUESTION ID) BIGINT(20) NOT_NULL
• a_mc_answer TEXT NULL
I'm unsure about how to store the wrong answers of the multiple choices in the answers table.
How should I store the incorrect answers, though? I thought that using some sort of string separator, but I'm not sure this would be a good idea...