在线考试系统数据库设计.doc
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
数据库设计 (1)概念设计 开发在线考试系统时,为了灵活地维护系统,设计了后台管理员模块,通过后台管 理员模块可以方便地对整个在线考试系统进行维护。此外,本系统的用户还应包括教师 和学生。基础数据表还可以有:院(系)表、专业表、班级表、科目表(与系、专业关 联),与考试相关的试卷基本表、试卷详细表、评分表。 (2)逻辑结构设计 根据设计好的E-R图在数据库中创建各表,系统数据库中各表的结构如下。 教师详细表信息(tb_teaching) 教师表信息(Tb_teacher) 学生表( Tb_student) 管理员信息表(tb_Admin) 学生表信息( Tb_student) 应用题信息表(tb_application) 班级信息表(tb_class) 课程信息表(tb_course) 系表信息(tb_department) 单选题表(TB schoose) 多选题表(Tb_mchoose) "管理员信息表(tb_Admin) " "字段名 "数据类型 "长度 "主键 "描述 " "ID "Int "4 "是 "系统编号 " "AdminID "Varchar "50 "否 "管理员编号 " "AdminName "Varchar "50 "否 "管理员姓名 " "AdminPwd "Varchar "50 "否 "管理员密码 " "教师表(Tb_teacher) " "字段名 "数据类型 "长度 "主键 "描述 " "ID "Int "4 "是 "系统编号 " "TeacherID "char "16 "否 "教师ID " "TeacherName "varchar "50 "否 "教师名字 " "TeacherPwd "varchar "50 "否 "教师密码 " "TeacherRoler"char "4 "否 "教师角色 " "Description "varchar "250 "否 "描述 " "Sex "char "2 "否 "性别 " "DepartmentID"char "16 "否 "系ID " "Professional"char "16 "否 "职业ID " "ID " " " " " "学生表( Tb_student) " "字段名 "数据类型 "长度 "主键 "描述 " "ID "Int "4 "是 "系统编号 " "StudentID "char "16 "否 "学生ID " "StudentName "varchar "50 "否 "学生名字 " "Sex "char "2 "否 "性别 " "StudentPwd "varchar "50 "否 "学生密码 " "ClassID "char "16 "否 "班级ID " "Description "vachar "250 "否 "描述 " "应用题表(Tb_application) " "字段名 "数据类型 "长度 "主键 "描述 " "ID "Int "4 "是 "系统编号 " "questionID "Char "16 "否 "问题编号 " "questionText"nvarchar "250 "否 "问题文本 " "questionURL "nvarchar "50 "否 "问题地址 " "answer "nvarchar "250 "否 "答案 " "chapter "nvarchar "10 "否 "章节 " "CourseID "Char "16 "否 "课程号 " "TeacherID "Char "16 "否 "教师号 " "share "Char "2 "否 "共享 " "班级表(Tb_class) " "字段名 "数据类型 "长度 "主键 "描述 " "ID "Int "4 "是 "系统编号 " "ClassID "Char "16 "否 "班级编号 " "ClassName "Varchar "50 "否 "班级名 " "StudenNumber"Int "4 "否 "学生人数 " "Grade "Char "10 "否 "年级 " "Professional"Char "16 "否 "职业号 " "ID " " " " " "DepartmentID"Char "16 "否 "系号 " "ManagerID "Char "16 "否 "管理员号 " "ClassDescrip"Varchar "250 "否 "班级描述 " "tion " " " " " "课程表(Tb_course) " "字段名 "数据类型 "长度 "主键 "描述 " "ID "Int "4 "是 "系统编号 " "CourseID "Char "16 "否 "课程号 " "CourseName "Varchar "50 "否 "课程名 " "Cou
- 粉丝: 84
- 资源: 9357
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助