数据库设计教务管理系统.doc

《数据库设计教务管理系统.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、计算机科学与技术学院、软件学院数据库设计与开发实验报告教务管理系统学生：学号：班级：指导老师：目录 第1章需求分析...........................................................................................................................3第2章数据库设计................................................................................

2、.......................................32.1E-R图分析..................................................................................................................................32.2数据库表设计................................................................................

3、.............................................42.2.1zhj_course表结构............................................................................................................42.2.2zhj_student表结构.............................................................................

4、..............................42.2.3zhj_teacher表结构..........................................................................................................42.2.4zhj_C_T表结构.................................................................................................

5、.............42.2.5zhj_C_S表结构..............................................................................................................4第3章数据库程序设计.................................................................................................................53.1数据

6、库及表的定义.....................................................................................................................53.2为数据库各表建立索引.............................................................................................................53.3创建各表的存储过程..........

7、.......................................................................................................53.3.1普通存储过程（无参数）............................................................................................63.3.2带参数的存储过程...........................................

8、.............................................................73.3.3带output参数的存储过程....................................