create database teaching /*创建数据库*/
create table single_select /*单项选择题*/
( single_select_id int identity(1,1) not null, /*序号,主键*/
single_select_content varchar(500) not null, /*题目内容*/
answer_A varchar(100) not null, /*选项*/
answer_B varchar(100) not null,
answer_C varchar(100) not null,
answer_D varchar(100) not null,
standard_answer varchar(8) not null, /*标准答案*/
)
create table mutiple_select /*多项选择题*/
( mutiple_select_id int identity(1001,1) not null,/*主键*/
mutiple_select_content varchar(500) not null,
answer_A varchar(100) not null,
answer_B varchar(100) not null,
answer_C varchar(100) not null,
answer_D varchar(100) not null,
answer_E varchar(100),
answer_F varchar(100),
answer_G varchar(100),
answer_H varchar(100),
standard_answer varchar(16) not null,
)
create table estimation /*判断题*/
(
estimation_id int identity(2001,1) not null,/*主键*/
estimation_content varchar(500) not null,
standard_answer varchar(10) not null,
)
create table fill_blank /*填空题*/
( fill_blank_id int identity(3001,1) not null,/*主键*/
fill_blank_content varchar(500) not null,
blank_1_standard_answer varchar(20),
blank_2_standard_answer varchar(20),
blank_3_standard_answer varchar(20),
blank_4_standard_answer varchar(20),
blank_5_standard_answer varchar(20),
)