How to create database for multiple choice questions

Database structure for multiple choice examination. I am developing a demo application for an online multiple choice examination. Each question will have multiple options, of course. On the question screen, candidate will select one of the option, submit it and will be navigated to the next question. I have worked out following table structure.

Solution 1. This may help you to kick-start: Copy Code. 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.

How to create a multiple choice quiz in PHP and MySQL

How to create a multiple choice quiz in PHP and MySQL. In this article, … So let’s create a database using the following query. Here is a table ‘questions’ that contains all the quiz questions. CREATE TABLE IF NOT EXISTS `questions` ( `qid` int(11) NOT NULL AUTO_INCREMENT, `question` varchar(150) NOT NULL, `is_enabled` int(11) NOT NULL …

If there is a chance that same answer can be used for multiple questions, you might as well remove QuestionId from Answers table and add IsCorrect field to CorrectAnswers table. This will reduce the size of your database. However, if you make change to answer for one question, it will change it for all the questions that are using it.

People Also Searches how to create database for multiple choice questions

how to create database access
how to create database tables
how to create database server
how to create database access
how to create database tables
how to create database server

How to create a multiple choice quiz in CodeIgniter PHP and mySQL Video Answer

Leave a Reply

Your email address will not be published.