基于C/S的教学管理系统的设计与实现VB+SQL

基于C/S的教学管理系统的设计与实现
 
摘 要：本设计采用了当前流行的SQL Server 2000 关系型数据库作后台和微软公司的Visual Basic 6.0 可视化编程工具作前台，结合实际需求，运用现代软件学知识，创造性开发了1个基于C/S（Client/Server)的教学管理系统，实现了教师信息管理、学生信息管理、考试信息管理、系统管理与维护、打印报表等功能。本文论述了该系统的设计与实现过程，内容涵盖系统开发背景、系统需求分析、目标设计、数据库设计、模块设计、详细设计、各功能模块编码实现、系统测试等各个过程。同时讲述了Visual Basic 6.0 基础知识、SQL基础知识、C/S结构与B/S结构、ADO技术、数据库的设计理论和Visual Basic数据库项目开发等技术和开发者的心得体会。
关键词：C/S；教学管理系统；SQL；数据库；VB

The Management System of Teaching and Studying Based on the model of C/S
 
Abstract: This design adopted SQL Server 2000 relational Data Base Management System which was popular currently as its background and Visual Basic 6.0 Viewed Programmed tool from Microsoft Corporation as its proscenium. The design combined practical requirement, applied knowledge of modern software and developed a management system of teaching and studying creatively. In this paper, the procedure of research and implement on a Management System of Teaching and Studying based on the model of C/S (Client/Server) was discussed. It implemented function of the management of teachers’ information, function of the management of students’ information, function of the management of examination’s information, function of the management and maintenance of the system and the function of print and report forms. It contained the system’s development background, the system’s requirement analysis, the system’s goal design, the data base’s design, the model’s design, detail’s design, the programmes’ design, as well as the test toward to the system. It also told basic knowledge of Visual Basic 6.0 and SQL, the structure of C/S and B/S, the technology about ADO, the theory of designing data base and the technology of developing data base project in VB and the writer’s experience.  （科教范文网 fw.nseac.com编辑发布）
Keywords:  Client/Server; Management System of teaching and studying; Structured Query Language; Database; Visual Basic

 目录
前言 1
1 绪论 2
1.1 数据库基础知识 2
1.2 SQL语言简介 3
1.3 SQL SERVER 2000简介 4
1.4 VISUAL BASIC简介 5
1.5 C/S结构和B/S结构 6
1.6 ADO技术 7
2 需求分析 8
2.1教学管理系统的需求 8
2.2 项目功能需求 9
2.3 教学管理系统的性能需求 9
3 数据库详细设计 10
3.1 基本数据信息 10
3.2 数据流图 14
3.3 E-R图 15
3.4 数据流条目： 18
3.4.1 学生信息管理模块： 18
3.4.2 教工信息管理模块： 18
3.4.3 成绩管理模块： 19
4 详细设计 21
4.1 系统整体数据流图 22
4.2 功能模块图 23
4.3 系统主窗口运行界面图 24
4.4 子功能模块设计 24
4.4.1 学生信息管理模块 24
4.4.2 教工信息管理模块 28
4.4.3  考试信息管理模块 31
4.5基础数据维护 35
4.5.1部门信息维护 35
4.5.2年级信息维护 35
4.5.3班级信息维护 35
4.6操作员命令 36
4.6.1系统管理 36
4.6.2退出系统 36
5 系统测试 37
6 总结 38
参考文献 39
致谢 40

注:不包括源代码.