Please help! I am trying to find a way to create a multiple choice test, using SQL.
This sure sounds like homework. If I do the homework for you, do I get the grade?
Let's think this through logically. You have a test. That test has questions. Each question has a list of possible answers. There are three tables (maybe four or five depending on if you want to reuse questions in multiple tests or answers in multiple questions). On top of that you have a test taker. That test taker has answers to a test. There are another couple of tables (although, again, you could make it more flexible with many-to-many joins, but you don't need that much to meet the base requirements).
You need to just create the table structures, some primary keys and foreign keys now. Should be pretty easy from here.
answered Jan 12 '12 at 06:45 AM
Grant Fritchey ♦♦
A multiple choice test would be built up in a similar way to pretty much any other data model.
A test has questions, a question has answers. A test has test takers and they mark which answer belonging to a question they think is the right one.
We will gladly support your efforts if you post them on this site, but I doubt anyone will design the entire thing for you.
I may be wrong, but this sounds like homework. If so, it should be made clear when asking the question. And I may be being cheeky, but placing a deadline of tomorrow makes it seem like you have left it to the last minute.
answered Jan 12 '12 at 06:49 AM