《数据库原理与应用》综合性实验报告
学生成绩管理系统数据库设计方案
学号：201130560210 姓名： 柯 俊 展
目录
一、 系统开发目标 ······················································································ 2 二、 数据库需求分析 ··················································································· 2 三、 数据流图····························································································· 2 数据流图： ······································································································ 2 四、 数据库设计 ························································································· 3 E—R图： ······································································································· 3 数据字典： ······································································································ 3 五、 逻辑结构设计 ······················································································ 4 关系模式： ······································································································ 4 六、 数据库实施 ························································································· 5 创建表： ········································································································· 5 权限设置： ····································································································· 10 创建触发器： ·································································································· 13 教师输入并查询数据： ····················································································· 13 创建函数： ····································································································· 14 插入数据到score: ····························································································· 15 学生登陆查询信息： ························································································ 16 教务员登陆查询信息： ····················································································· 16 成绩分析： ····································································································· 17 总结： ··········································································································· 18 附录： ··········································································································· 19 参考文献： ····································································································· 27
1
一、 系统开发目标
建立一个学生成绩管理数据库系统，用于数据的输入、修改和查询，满足任课教师、学生、教务员等用户的需求。
二、 数据库需求分析
明确系统的用户，收集和分析用户对系统的信息需求和处理需求： 1. 任课教师可以对所讲授课程进行成绩输入、修改和查看。
2. 学生可以按学号查询自己各门功课的成绩、总成绩、平均分、在班级中的排名等。
3. 教务员可以查询全体学生的成绩、对学生成绩进行排名等。 问题假设：
4. 此问题中只有一个班，四位同学，三位教师授课（即三门课，分别是英语、高等数学、数据库应用），一位教务员。 5. 查看平台是ORACLE SQL/Plus平台。 三、 数据流图
数据流图：
教师更新查询处理： 更新 成绩 查询要求 查询 成绩 查询统计信息提取 成绩信息表 教师 课程信息表 注册 教师信息表
2