question

Amber-Rose avatar image
Amber-Rose asked

HELP! Multiple Choice!!!!!

Please help! I am trying to find a way to create a multiple choice test, using SQL. The test requires the question, multiple choice answers, and at the end to show a percentage as a result of how well the test taker has done, and to show the actual results of the test. The most important element is for the tables to be able to detect whether the test taker has submitted a right or wrong answer, and show this at the end of the test. This is for a website that will be up and running in a few days. No one in my office has any idea of how to do this, and its my job to find out. I only started working here 3 weeks ago as an apprentice, and i literally knew NOTHING when i started, and im still not 100% on everything, so any help would be appreciated! Thanks.
sql-server-2005sqlhelptesting
6 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Nah, I was willing to meet her half-way on this one.
1 Like 1 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
@amber-rose - a few others have alluded to the point that this might be a homework question. Can you tell us whether it is or not please? There is no reason for it not to be, we just want to make sure we offer help at an appropriate level. We love having students ask questions here are it gives us the chance to avoid people learning the wrong way.
1 Like 1 ·
Shawn_Melton avatar image Shawn_Melton commented ·
Sad to say with your question worded in that manner you are not likely to get any answers. You might want to provide more detailed information as to why you need this and what you exactly want. If you are looking for a silver plater with the answer, wishful thinking.
0 Likes 0 ·
Shawn_Melton avatar image Shawn_Melton commented ·
Well you have all that spare time, unlike the rest of us here ;)
0 Likes 0 ·
Amber-Rose avatar image Amber-Rose commented ·
Better now? ;)
0 Likes 0 ·
Show more comments
Grant Fritchey avatar image
Grant Fritchey answered
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.
6 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image WilliamD commented ·
Well, you got in there before me and it seems we're on the same wavelength here. I give you an B+ (you didn't show your work) ;)
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
I hate that requirement. Isn't getting the right answer enough?
0 Likes 0 ·
Amber-Rose avatar image Amber-Rose commented ·
Thank you so much! Very helpful! :)
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
@Grant - just being pedantic! I hated it when teachers said that to me too.
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
I know. I was just whining at you the way I used to whine at my teachers.
0 Likes 0 ·
Show more comments
WilliamD avatar image
WilliamD answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Amber-Rose avatar image Amber-Rose commented ·
Hi, i only got given this to find out about an hour ago, my boss needs an answer before tomorrow and none of us here have a clue how to do it, this seemed like the logical way of finding out! this has been such a help already, so thanks alot!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.