Home >Backend Development >PHP Problem >How to design the PHP multiple-choice question database

How to design the PHP multiple-choice question database

angryTom
angryTomOriginal
2019-11-08 16:44:212988browse

How to design the PHP multiple-choice question database

How to design the php multiple-choice question database

php multiple-choice question data table can be designed as follows:

E-R diagram

How to design the PHP multiple-choice question database

##Multiple choice data table

##tinyintnot null IDENTITY(1, 1) primary key##ChoiceQst_Question##not nullOperation# #textChoiceQst_OP3##textnot nullChoiceQst_answ

##Column Name

Description

##Data type

constraint

ChoiceQst_id

##Question number

##Question model

int

##not null

##foreign key

##ChoiceQst_Info

#Content

text

##not null

##ChoiceQst_OP1

##Operation

1

#text

##ChoiceQst_OP2

2

not null

Operation3

##text

##not null

##ChoiceQst_OP4

##Operation

4

#Answer

char

##not null

For more PHP related knowledge, please visit PHP Chinese website

!

The above is the detailed content of How to design the PHP multiple-choice question database. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:what is phpbbNext article:what is phpbb