Online Test Application - Database Design |
|
Answered By
Moderator1
on
12/18/2009 9:57:47 PM |
|
|
|
|
Hi,
Online Test Application can be designed with simple database tables.
1. Questions Table - Question code, question subject/description
2. Answer Option Table - Answer Code, Question Code, Answer Description, Answer Sort Order
3. AnswerToQuestion Table - This table will have the correct answers for every questions. If multiple answer, then this table will have more than 1 row for a question. Fields are Question Code and Answer Code.
Design your database like the above, and if you need any more information you can reply to this post. |
|
|
|