目录
一、 二、
需求分析（11） ··················································································1 概要设计（全体组员） ·········································································4
（一）学生管理（11） ··············································································5 （二）教师管理（11） ··············································································5 (三) 教材管理（11） ················································································6 （四）班级管理（11） ··············································································6 （五）教学管理（11） ··············································································7 （六）成绩管理（11） ··············································································7 （七）课程管理（11） ··············································································8 （八）系部管理（11） ························································································· 8 三、详细设计（全体组员） ·············································································9 四、调试分析： ··························································································· 10
（一）学生管理（11） ············································································ 18 （二）教师管理（11） ············································································ 20 (三) 教材管理（11） ·············································································· 21 （四）班级管理（11） ············································································ 22 （五）教学管理（11） ············································································ 23 （六）成绩管理（11） ············································································ 24 （七）课程管理（11） ············································································ 26 （八）系部管理（11） ······················································································· 27 五、用户使用说明（11） ·············································································· 28 六、测试结果示例（11） ·············································································· 29 七、心得体会（11）····················································································· 29 参考文献 ： ······························································································· 34
摘 要：数据库技术是计算机科学技术中发展最快的领域之一，也是应用范围最广、实用性很强
的技术之一，它已成为信息社会的核心技术和重要基础。在Internet告诉发展的信息化时代，信息资源的经济价值和社会价值越来越明显，建设以数据库为核心的各类信息系统，对提高企业的竞争力与效益、改善部门的管理能力与管理水平，都具有实实在在的重要意义。
教务管理系统就是在数据库的基础之上对学校教务信息进行操作，实现数据的修改、存储、分析等操作。教务人员通过学生信息管理模块来管理学生信息，如进行学生信息的添加、修改、删除等；教务工作人员通过此模块来管理教师信息，包括教师信息的添加、修改、删除等； 教务工作人员通过该模块来管理课程的基本信息，包括课程信息的添加，修改，删除和班级课程的设置等；教务工作人员通过该模块来进行学生成绩的管理，在进行学生成绩的添加时，可用它来为学生设置所在班级的课程表来直接输入成绩；通过该模块可以查询教务所需要的各种信息；教务工作人员可以通过打印模块来打印学生成绩信息，选课记表和班级表。例如：学生信息查询提供了包括学生学号、姓名、所在班级、班主任名字和宿舍等信息，学生信息进行查询的各种查询条件，用户可以根据单个的查询条件或者它们的组合来进行查询。整个系统实现了教务信息实时性更新，给学校提供了一个高效性、准确性的信息存储系统；方便了广大用户，为学校现代化发展提供了有利保障
关键词：数据库、教务管理、信息系统、存储系统
一、需求分析（11）
随着学校的规模不断扩大，学生数量急剧增加。有关学生的各种信息量也成倍的增长。面对庞大的信息量，就需要由教务信息管理系统来提高学生管理工作的效率。通过教务管理系统，可以做到信息的规范化管理、科学统计和快速查询，从而减少管理方面的工作量。 学校为方便学生、老师、教务管理人员信息查询，注册以及信息修改，学校把学生信息，包括姓名、性别、年龄、成绩等信息输入教务管理系统的数据库，然后在终端可以对数据进行查询和修改造作。要求生成数据库系统所有需要的表以及表之间的关系，所有查询通过视图来实现，所有维护和管理工作通过存储过程来实现，对数据库
1
查询进行优化，建立需要的索引。 以下为教务管理系统需求分析图
教务管理系统需求分析图
数据字典：（11）
学生管理实体
2
系信息表实体
教室管理实体
成绩管理实体
班级管理实体
教材管理实体
课程信息表实体：
3
教学管理实体
二、概要设计（全体组员）
教务管理系统设计实现对有关学生的信息、有关教师的信息、有关每个系部的信息、有关每个班级的信息、有关课程及使用教材的信息、有关课程安排的信息的存储、查询、维护。（概要设计CDM图如下）
4