Hi all there,
I need your help in my project of "online examination”. I am developing this for my lab.
frontend: ASP
backend: SQL Server 2000
Now the requirements r:
1. I have to generate papers which randomly select 100 MCQs from table and displays on client computers. The time limit for paper is 2 hours.
2. Now after submission of paper another task is to calculate their result and display it on client.
3. Solved papers of clients also have to store for record.
Now correct me if I am wrong. I have 5 tables as:
STUDENT: std_id, std_name, std_fname, e-mail
SUBJECT: subj_id, subj_name
QUESTION: q_sno, subj_id, question, opt1, opt2, opt3, opt4, answer
PAPER: p_sno, std_id, paper, date
RESULT: ??????????
Now I want that the result should like:
Total attempt
Network 15 13
Java 15 14
DLD 15 10
Etc
But now I m confused please help me.
Thanks in advance
Last edited by tania khan; Jan 28th, 2009 at 1:57 am.
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
This thread is currently closed and is not accepting any new replies.
Previous Thread in MS SQL Forum Timeline:Sql server