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.
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.
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.