
September 30th, 2004, 06:56 PM
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Question on online test website design, can it be done?
I want to know if this can be done and maybe if you can pitch in on the best way of doing it.
I'm not very good at ASP but I need to get something started for work, like a sample site.
I have a SQL database with the following tables: tblClients, tblTests, tblQuestions, and tblAnswers.
The tblClients table has client information and which test they created. The tblTests table has the test ID number and test information.
The tblQuestions table has the Test Id and questions. The tblAnswers table has the test ID and the answers with the correct answer
flagged as correct.
So, the ASP program needs to get all this together in the webpage when someone is taking a test. It needs to put the question at the top of the page and the answers at the bottom with radio buttons to select the answer. The student selectsd the answer and the next question is taken from the tblQuestions table and placed at the top, with the related answers listed for selection. I think I'm answering my question but I'm confused with all the joins.
Any help helps. Thanks in advance.
|