在線考試系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)(表)

經(jīng)典word整理文檔，僅參考，雙擊此處可刪除頁眉頁腳。本資料屬于網(wǎng)絡(luò)整理，如有侵權(quán)，請聯(lián)系刪除，謝謝！MulQuestionsYNQuestionsFillQuestions此表保存所有的多選題信息此表保存所有的判斷題信息此表保存所有的填空題信息各表的結(jié)構(gòu)設(shè)計(jì)如下：1.用戶管理表(Users)類型用戶編號varcharUserName用戶姓名varcharUserPwd登錄密碼varcharUserType用戶類型varchar1234不允許為空不允許為空不允許為空202.學(xué)生信息表(StudentInfo)位數(shù)20202050204123456varchar不允許為空不允許為空不允許為空不允許為空不允許為空J(rèn)oinYear入學(xué)年份varchar.考試管理表(ExamManage)序號1不允許為空不允許為空不允許為空不允許為空不允許為空不允許為空不允許為空不允許為空5.6.7.8.9.屆數(shù)年級學(xué)期專業(yè)varcharvarcharvarcharvarchar202050TermMajor4.課程管理表(SubjectInfo)課程編號Intvarcharvarcharvarcharvarcharvarchar不允許為空不允許為空不允許為空不允許為空不允許為空GradeTerm20205050MajorSubject6.課程名5.試卷管理表(PaperManage)類型考試代碼varchar20主鍵PaperNo試卷編號int4主鍵Subject考試科目varchar50不允許為空試題類型varchar20不允許為空QuestionType試題編號int試題分?jǐn)?shù)int44不允許為空不允許為空6.QuestionMark6.成績管理表(ScoreManage)序號字段名稱ExamCodeStudentIDSubjectScore字段說明考試代碼varchar20學(xué)號varchar20考試科目varchar50成績int1234不允許為空不允許為空不允許為空不允許為空47.單選題題庫表(SingleQuestions)字段名稱不允許為空不允許為空不允許為空不允許為空不允許為空不允許為空7.QuestionNo8.QuestionA9.QuestionB10QuestionC11QuestionD12Answer選項(xiàng)內(nèi)容1varchar500不允許為空選項(xiàng)內(nèi)容2varchar500不允許為空選項(xiàng)內(nèi)容3varchar500允許為空選項(xiàng)內(nèi)容4varchar500允許為空正確答案varchar1不允許為空8.多選題題庫表(MulQuestions)Majorvarcharvarcharvarchar50不允許為空20不允許為空50不允許為空GradeSubject不允許為空20不允許為空4不允許為空6.UserIDvarcharint7.QuestionNo8.QuestionA9.QuestionB10.QuestionC11QuestionD12QuestionE13.QuestionF14.Answer500不允許為空500不允許為空500不允許為空500允許為空500允許為空500允許為空12不允許為空正確答案varchar9.判斷題題庫表(YNQuestions)題庫題號intMajor不允許為空不允許為空不允許為空不允許為空不允許為空不允許為空不允許為空不允許為空GradeSubject考試科目varchar506.UserID出題人試題編號int試題內(nèi)容varchar500正確答案int7.QuestionNo8.Question9.Answer410.填空題題庫表(FillQuestions)題庫題號intMajor不允許為空不允許為空不允許為空不允許為空不允許為空不允許為空不允許為空不允許為空GradeSubject考試科目varc