AspdotnetCodes.com
Search
Articles
Books
Resources
Asp.Net News
Downloads
Free Tech Magazines
Asp.Net Web Hosting
Archives
Softwares
Newsletter
Suggest Us
Link to Us
Feeds Subscription
Articles
Questions & Answers
Tips & Tricks
 online test applicattion
Posted by rutika shihoorkar on  12/14/2009 5:31:49 AM Category: Asp.Net 2.0
Add to my favorites
Email to friend
how can i add online application in my project...i m really confused about database also...
how can store all questions, answer and correct answer plz help

Post Your Reply Post New Question

 Viewer's Reply
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.
 
Post Your Reply If you still have problem, post it again under this reply for better response.

 
Sponsored by
Integrating Silverlight 4 with SharePoint 2010 - Free 42 Page Sample Chapter
The Beginner's Guide to Joomla
Run Your Own Web Server Using Linux & Apache - Free 191 Page Preview