目录
第 1 章
需求分析.....................................................................................................................3
第 2 章
数据库设计...................................................................................................................4
2.1 E-R 图分析..................................................................................................................................4
2.2 数字库表设计.............................................................................................................................4
2.2.1class 表结构...............................................................................................................4
2.2.2course 表结构.................................................................................................................4
2.2.3 facutly 表结构.............................................................................................................5
2.2.4 grade 表结构.....................................................................................................................5
2.2.5 student 表结构.....................................................................................................................5
2.2.6 teacher 表结构.....................................................................................................................5
第 3 章 数据库程序设计.................................................................................................................6
3.1 数据库及表的定义.....................................................................................................................6
3.2 数据库各建立视图 ...........................................................................................................6
3.3 为数据库各表建立索引.............................................................................................................6
3.4 创建各表的存储过程.................................................................................................................7
3.4.1 普通存储过程（无参数）............................................................................................7
3.4.2 带 input 参数的存储过程........................................................................................................7
3.4.3 带 output 参数的存储过程............................................................................................8
3.5 触发器设计.................................................................................................................................9
3.5.1 插入触发器....................................................................................................................9
3.5.2 更新触发器..................................................................................................................10
3.5.3 删除触发器..................................................................................................................10
3.6 游标的应用...............................................................................................................................10
第 4 章 用户交互界面...................................................................................................................11
4.1 登录界面模块........................................................................................................................11
4.2 学生模块........................................................................................................................12
4.3 任课教师模块..............................................................................................................12
4.4 班主任模块....................................................................................................................13
4.5 系主任模块..............................................................................................................14
第 5 章 总结...................................................................................................................................16
第 1 章
