Database design for a multiple choice queston website

Question

1.00/5 (2 votes)

See more:

How do I create database for a MCQ website such that I have 3 sections physics chemistry and maths and i have different sub topics from each of the section. I want to store minimum 20 questions of each topics. I want to store the questions, choices and correct ans in such a way that every questions of sub-topics get stored in same table but questions of different section`s sub-section get stored in different one.

What I have tried:

I was creating 3 table one for sections and one for questions and one for the choices but i am having difficulty in storing questions for individual sub-section

Posted 17-Feb-17 20:49pm

Member 13008699

Updated 18-Feb-17 9:42am

Patrice T

Add a Solution

Comments

Richard MacCutchan 18-Feb-17 4:31am

"i am having difficulty"
Sorry, but no one here can guess what that is supposed to mean. Please edit your question and add some proper technical detail.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2017-02-18T01:19:00

This may help you to kick-start:

section table   topic table	  question table	  choice table    answer table
section_id	    topic_id      question_id         choice_id	      question_id
section_title   topic_title   question_desc       choice_desc     choice_id
  	            section_id    topic_id	          question_id

Database design is an iterative process. The final design will depends on the user's requirements and other considerations such as the ease of database operations.
If you are new to database design, then you should learn:
1. Introduction to database design[^]
2. 1NF, 2NF, 3NF and BCNF in Database Normalization[^]

Patrice T · Answer 2 · 2017-02-18T09:42:00

Solution 2

Quote:
How do I create database for a MCQ website

Database design is a vast subject and certainly out of scope of a QA question.

Quote:
i am having difficulty in storing questions for individual sub-section

This and nothing is the same.

Posted 18-Feb-17 9:42am

Patrice T

Comments

Member 13008699 19-Feb-17 3:39am

then pls u suggest what shoud
i do?