没有合适的资源?快使用搜索试试~ 我知道了~
数据库课程设计报告-教务管理系统.pdf
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 72 浏览量
2022-11-03
09:03:01
上传
评论
收藏 2.19MB PDF 举报
温馨提示
试读
40页
。。。
资源推荐
资源详情
资源评论
. .
目录
一、
二、
需求分析(11)·········································································2
概要设计(全体组员)·································································5
(一)学生管理(11) ·····································································5
(二)教师管理(11) ·····································································6
(三) 教材管理(11) ·······································································6
(四)班级管理(11) ·····································································7
(五)教学管理(11) ·····································································7
(六)成绩管理(11) ·····································································8
(七)课程管理(11) ·····································································9
(八)系部管理(11)
················································································ 9
三、详细设计(全体组员)··································································· 10
四、调试分析: ················································································ 11
(一)学生管理(11) ··································································· 20
(二)教师管理(11) ··································································· 22
(三) 教材管理(11) ····································································· 23
(四)班级管理(11) ··································································· 25
(五)教学管理(11) ··································································· 27
(六)成绩管理(11) ··································································· 28
(七)课程管理(11) ··································································· 29
. 专业资料.
(八)系部管理(11)
·············································································· 30
五、用户使用说明(11) ····································································· 32
六、测试结果示例(11) ····································································· 33
七、心得体会(11)··········································································· 33
参考文献 : ···················································································· 39
摘 要:
数据库技术是计算机科学技术中发展最快的领域之一,也是应用围最广、实用性很强的
技术之一,它已成为信息社会的核心技术和重要基础。在 Internet 告诉发展的信息化时代,信息资源
的经济价值和社会价值越来越明显,建设以数据库为核心的各类信息系统,对提高企业的竞争力与效
益、改善部门的管理能力与管理水平,都具有实实在在的重要意义。
教务管理系统就是在数据库的基础之上对学校教务信息进行操作,实现数据的修改、存储、分
析等操作。教务人员通过学生信息管理模块来管理学生信息,如进行学生信息的添加、修改、删除等;
教务工作人员通过此模块来管理教师信息,包括教师信息的添加、修改、删除等; 教务工作人员通
过该模块来管理课程的基本信息,包括课程信息的添加,修改,删除和班级课程的设置等;教务工作
人员通过该模块来进行学生成绩的管理,在进行学生成绩的添加时,可用它来为学生设置所在班级的
课程表来直接输入成绩;通过该模块可以查询教务所需要的各种信息;教务工作人员可以通过打印模
块来打印学生成绩信息,选课记表和班级表。例如:学生信息查询提供了包括学生学号、姓名、所在
班级、班主任名字和宿舍等信息,学生信息进行查询的各种查询条件,用户可以根据单个的查询条件
或者它们的组合来进行查询。整个系统实现了教务信息实时性更新,给学校提供了一个高效性、准确
性的信息存储系统;便了广大用户,为学校现代化发展提供了有利保障
关键词
:
数据库、教务管理、信息系统、存储系统
1
一、需求分析(11)
随着学校的规模不断扩大,学生数量急剧增加。有关学生的各种信息量也成倍的增
长。面对庞大的信息量,就需要由教务信息管理系统来提高学生管理工作的效率。通过
教务管理系统,可以做到信息的规化管理、科学统计和快速查询,从而减少管理面的工
作量。 学校为便学生、老师、教务管理人员信息查询,注册以及信息修改,学校把学生
信息,包括姓名、性别、年龄、成绩等信息输入教务管理系统的数据库,然后在终端可
以对数据进行查询和修改造作。要求生成数据库系统所有需要的表以及表之间的关系,
所有查询通过视图来实现,所有维护和管理工作通过存储过程来实现,对数据库查询进
行优化,建立需要的索引。
以下为教务管理系统需求分析图
教务管理系统需求分析图
2
数据字典
:(11)
学生管理实体
系信息表实体
教室管理实体
成绩管理实体
3
班级管理实体
教材管理实体
课程信息表实体:
教学管理实体
4
剩余39页未读,继续阅读
资源评论
不吃鸳鸯锅
- 粉丝: 8356
- 资源: 2万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功