本科毕业设计论文
题 目 明德教室管理系统——数据库设计及教室分配
专业名称 计算机科学与技术
学生姓名 王
指导教师 李伟华
毕业时间 2013年6月
西北工业大学明德学院本科毕业设计论文
摘 要
高校教室管理系统针对各大高校教室众多，课程众多，提供检索筛选功能，方便师生上课，也方便工作人员管理教室资源。传统的教室管理模式局限于纸介，不易信息收集和管理，而且正确比较低，修改较麻烦。基于目前这种现状，高校教室管理系统不仅仅给需要信息的师生提供方便，更重要的是应对信息化的今天，改变传统的信息管理模式，减少学校对信息管理的工作量，提高工作效率，实现信息与人才的优化。
当今，高等教育学院的发展已经深入到教学活动的各个方面，老师、课程考试负责人，教务科、管理员等都可以同过教务管理系统平台，实现自身教学管理与规范合为一体的高质量体系，达到规范教学秩序的目的。为了方便用户的使用，提高办事效率，就要设计出一套应用简单、易于操作的后台管理系统，实现对教学资源的日常维护。
由此需出发，该系统为教师申请教学资源，课程考试负责人制定授课计划，管理员查询核对信息提供了方便，达到规范教学秩序的目标。本系统是以Microsoft Visual Studio 2008为主要开发工具，用C#技术构建前台页面，以SQL Server 2000 数据库作为后台支持，该系统具有操作简单、界面友善、灵活性好、系统安全性高、运行稳定等特点。
本项目是教室分配管理系统，其中，主要实现：教室分配管理，教学资源申请与查询管理，资源基本信息管理，学生基本信息管理，系部基本信息管理等五大模块的功能。同时分为普通教师，课程考试负责人，系教务科，管理员四个身份等级。项目基于.Net平台，是一个针对后台管理的系统，应用多层框架技术实现。最后，总结了系统的特点和优势及不足之处，并对未来的发展和应用前景做了展望。
关键词：教室分配系统；C#开发；三层架构
I
西北工业大学明德学院本科毕业设计论文
Abstract
University classroom management system for a number of major college classrooms, many courses, providing access to screening function to facilitate the school teachers and students, and classroom resources to facilitate staff management. Limited to the traditional paper medium classroom management, information collection and management is not easy, and right lower, than the troublesome changes. Based on the current situation, not only to the university classroom management system, teachers and students need information to provide convenient, more importantly, deal with information today, to change the traditional mode of information management, reduce the workload of the school of information management to improve efficiency realize the optimization of information and personnel.
Today, the development of the Institute of Higher Education into the teaching activities, teachers, curriculum, the person in charge of Academic Affairs Division, the administrator can all be the same over the educational management system platform to achieve their own system of teaching, management and norms as one of high quality, to standardize the teaching order. Order to facilitate the use of the user, improve efficiency, it is necessary to design a set of applications simple and easy-to-background management system, and routine maintenance of teaching resources.
Which required starting the system to apply for a teaching resource for teachers, the course is responsible for development of lesson plans, the Administrator to verify information to provide a convenient, to achieve the goal of standardizing teaching order. This system is based on Microsoft Visual Studio 2008 as the main development tool, built using C # technology front page, SQL Server 2000 database as the back-office support, the system has a simple, friendly interface, flexibility, the system safe and stable operation features.
This project is a classroom distribution management system, which, the main achievement: the allocation of classroom management, teaching resources for the query management, resources, information management,
II
西北工业大学明德学院本科毕业设计论文
teachers, information management, department of basic information management functions of the five modules. Divided into ordinary teachers, curriculum person in charge of the Department of Academic Affairs Division administrator four identity rating. The project is based on the Net 2005 platform is a system for Admin application of multi-layer framework technology. Finally, sum up the features and advantages of the system and inadequacies, and future development and application prospect.
Keywords: Classroom distribution systems; C # development; three-tier system
III
西北工业大学明德学院本科毕业设计论文
目 录
摘 要 .......................................................................................................................... I Abstract ....................................................................................................................... II 目 录 ......................................................................................................................... 1 第1章 引 言 ............................................................................................................ 3 1.1 应用背景 ................................................................................................................... 3 1.2教室分配管理意义 .................................................................................................... 4 1.3 本文的研究目的及文章安排 ................................................................................... 5 第2章 可行性分析及相关工具.................................................................................. 6 2.1可行性分析 ................................................................................................................ 6
2.1.1经济可行性分析 .................................................................................................. 6 2.1.2 技术可行性分析 ................................................................................................. 7 2.1.2 操作可行性分析 ................................................................................................. 7 2.1.2 法律可行性分析 ................................................................................................. 7 2.2相关技术介绍 ............................................................................................................ 7 2.2.1 开发工具 ............................................................................................................. 7 2.2.2 ADO.NET数据库访问技术 ................................................................................... 9 2.2.3数据库 ................................................................................................................ 10 2.3本章小结 .................................................................................................................. 11 第3章 需求分析 ...................................................................................................... 12 3.1 问题定义 .................................................................................................................. 12 3.1.1 学生使用系统的功能要求 ............................................................................... 12 3.1.2管理员使用系统的功能要求 ............................................................................ 12 3.2 需求分析 .................................................................................................................. 13 3.2.1 系统功能需求 ................................................................................................... 13 3.2.2 安全性与完整性需求 ....................................................................................... 13 3.2.3 数据流程图与功能划分 ................................................................................... 14 3.3 本章小结 .................................................................................................................. 15 第4章 数据库设计 .................................................................................................. 16 4.1 数据库设计 .............................................................................................................. 16
1