MS SQL

MS SQL RSS

urgent help for "online examination" project

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Jan 2009

Posts: 5

Reputation: tania khan is an unknown quantity at this point

Solved Threads: 0

tania khan tania khan is offline

Offline

Newbie Poster

urgent help for "online examination" project

Jan 28th, 2009

Help with Code Tags

(Toggle Plain Text)

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.

•

Join Date: May 2006

Posts: 1,855

Reputation: ithelp is a name known to all

Solved Threads: 120

ithelp

Offline

Posting Virtuoso

Re: urgent help for "online examination" project

Jan 28th, 2009

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.

•

Join Date: Jan 2009

Posts: 5

Reputation: tania khan is an unknown quantity at this point

Solved Threads: 0

tania khan tania khan is offline

Offline

Newbie Poster

Re: urgent help for "online examination" project

Jan 28th, 2009

•

Originally Posted by 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.

Help with Code Tags

MS SQL Syntax (Toggle Plain Text)