学生选课信息管理(五组).docxVIP

数据库原理与应用系统设计 题 目 学生选课信息系统 组 员 王一中、向启源、叶晨、王力 班 级 14物联网工程班 学 院 电子信息工程学院 指导老师 喻剑平 2016年 11 月18 日 任务分配表 第五 组 学号 姓名 负责部分 成绩 组长 王一中 系统总体设计、文档审阅 组员 向启源 编写设计报告 叶晨 制作PPT答辩、文档排版 王力 需求分析 PAGE \* MERGEFORMAT14 目录 第一章 绪论··················································2 第二章 数据库需求分析········································2 1.功能分析················································3 2.性能分析················································3 3.系统的非功能性需求······································3 第三章 数据库概念设计········································3 1.概念结构················································3 2.数据字典················································4 3.E-R图分析···············································5 第四章 数据库逻辑结构设计····································7 1.学生关系模型············································7 2.教师关系模型············································7 3.教室关系模型············································7 4.选课关系模型············································8 5.学生成绩关系模型········································8 第五章 数据库实施阶段········································9 1.建立数据库··············································9 2.创建表··················································9 第六章 数据库运行和维护······································10 1.导入数据，完善5个表····································10 2.进行相关操作············································10 3.数据库安全设置··········································12 4.数据库的维护············································12 5.检测并改善数据库性能····································12 6.重新组织和构造数据库····································13 总结 ························································14 第一章 绪论 随着高校的多样全面发展，学生的人数和课程的种类急速增加，传统的选课管理模式已经无法满足当前的实际需求，学生选课作为一种信息资源的集散地，包含很多的信息数据的管理。由于数据繁多，容易丢失，且不易查找。并且数据处理手工操作工作量大，出错率高，出错后不易更改，造成各种不便，总的来说缺乏系统，规范的信息管理手段。尽管有的学校有计算机，但是尚未用于信息管理，没有发挥它的效力，资源闲置比较突出。 数据库作为存取数据并对数据进行操作的工具在系统中所起到的作用至关重要。数据库设计是指对于一个给定的应用环境，构造优化的数据库逻辑模式和物理模式结果，