计算机科学与技术学院、软件学院数据库设计与开发实验报告教务管理系统学生姓名：学号：班级：指导老师：目录 第 1 章 需求分析....................................................................................................................... ....3第 2 章 数据库设计................................................................................................................... ....32.1E-R 图分析..................................................................................................................................32.2 数据库表设计.............................................................................................................................4 2.2.1zhj_course 表结构............................................................................................................4 2.2.2zhj_student 表结构...........................................................................................................4 2.2.3 zhj_teacher 表结构..........................................................................................................4 2.2.4 zhj_C_T 表结构..............................................................................................................4 2.2.5 zhj_C_S 表结构..............................................................................................................4第 3 章 数据库程序设计.................................................................................................................53.1 数据库及表的定义.....................................................................................................................53.2 为数据库各表建立索引.............................................................................................................53.3 创建各表的存储过程.................................................................................................................5 3.3.1 普通存储过程（无参数）..................................................................
