urgent help for "online examination" project

[tania khan]

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

[ithelp]

First develop the database design and then use asp as front end to query and update database. Pretty simple final year project assignment I would say.

[tania khan]

First develop the database design and then use asp as front end to query and update database. Pretty simple final year project assignment I would say.

oh yeah!  so help me in its database.

[PRAGYACHITKARA]

hi i want the documentation of online exam software including srs erd dfd i/o interface etc so pls send me if u hv them prpared my mail id is <snip>