本科毕业论文(设计)物理与电子信息科学系教务管理系统的设计（可编辑）.doc

本科毕业论文(设计)物理与电子信息科学系教务管理系统的设计 关键词:教务管理系统;SQL Server数据库技术; Abstract Along with our countrys higher education career of booming development, college educational reform in comprehensive, the implementation of credit system in the schools in full swing, and university of automatic processing and information of the information network interactive way more and more recognized also application, let the computer to manage students information is now various colleges and universities in the positive enough work, and also one of the important work of college educational administration management one of beauty. This system to guiyang college educational administration of the department of electrical things work content for the actual background, mainly realizes user information management, information release and student performance management etc. Function This paper first introduced the college educational administration management system the research background, the introduction of the commonly used database technology, mainly is the SQL Server database technology; Detailed analysis of the function of the college educational administration management system requirements, the role of analysis, the business process and system target; This system were analyzed in the teaching management information system related entities, mainly including students, teachers, and information and course, etc Keywords: educational administration management system; SQL Server database technology; 目录 前 言 1 第一章 开发技术介绍 2 1.1 SQL Server简介 2 1.2 JAVA简介 2 第二章 系统分析 3 2.1需求分析 3 2.1.1 管理员功能的需求 3 2.1.2教师功能的需求 4 2.1.3学生功能的需求 5 2.2实体属性表 6 第三章 数据库的初步实现 7 3.1系统逻辑结构的设计 7 3.2数据库关系图 8 3.3 SQL 语句的实现 8 3.3.1数据表的创建 8 3.3.2 视图的创建 10 3.3.3 成绩排名的创建 10 第四章 系统界面的设计 12 4.1 登录界面的设计 12 4.2 学生信息添加界面 12 4.3 学生信息查询界面 13 4.4 学生成绩添加界面 14 设计总结及心得 16 致谢 17 参考文献 18 附录 19 前 言 当今社会是一个信息时代,计算机技术发展迅速,同时信息的自动处理以及网络式的信息交互方式越来越被人们认可和应用,让计算