How to structure a database with questions and answers?
- by Andreas Johannessen
Hi
I am going to make a simple application that uses a database. I could need some guidance on how to structure it.
I shall make question program. What I have in mind is.
One table with questions
One table
with the difficulity of the question
One table with the category of the
question
However, what do I do with the answers? Have them as seperate columns in the question-table? It sounds like a bad practice.(Also, where do I have the correct answer)
Each question will have 5 answers where only one of them is correct.