大學(xué)生檔案管理系統(tǒng)設(shè)計(jì)

摘 要：大學(xué)生檔案管理系統(tǒng)是高校管理系統(tǒng)中重要的組成部分，在某種程度上體現(xiàn)了一個(gè)學(xué)校的教學(xué)現(xiàn)代化水平，通過網(wǎng)站對(duì)學(xué)生信息進(jìn)行全面的，自動(dòng)化的管理，大大提高了學(xué)校的辦公效率。
大學(xué)生檔案管理系統(tǒng)是典型的信息管理系統(tǒng) (MIS),它的開發(fā)主要包括后臺(tái)數(shù)據(jù)庫的建立和維護(hù)以及前臺(tái)應(yīng)用程序的開發(fā)這兩個(gè)方面。對(duì)于前者要求建立起數(shù)據(jù)一致性和完整性強(qiáng)、數(shù)據(jù)安全性好的庫。而對(duì)于后者則要求應(yīng)用程序功能完善，便于使用等特點(diǎn)。通過調(diào)查所得結(jié)果，我決定采用微軟公司的Visual Studio 2005中的C#語言平臺(tái)來進(jìn)行開發(fā)，而后臺(tái)數(shù)據(jù)庫則建立在Microsoft SQL Server 2005的基礎(chǔ)上。在SQL Server 2005開發(fā)過程中，作為初學(xué)者的我們必須掌握的基礎(chǔ)知識(shí)和基本操作包括數(shù)據(jù)庫的基本操作，權(quán)限管理，如何創(chuàng)建數(shù)據(jù)庫表與數(shù)據(jù)完整性，如何使用視圖，索引，存儲(chǔ)過程，游標(biāo)和觸發(fā)器，以及用戶定義數(shù)據(jù)類型和函數(shù)等等。
本次畢業(yè)設(shè)計(jì)我通過對(duì)計(jì)算機(jī)硬件以及軟件方面的知識(shí)的學(xué)習(xí),進(jìn)行論證了這個(gè)系統(tǒng)的解決方案。并且對(duì)學(xué)校以及其他地域進(jìn)行了調(diào)查和系統(tǒng)的分析，根據(jù)在學(xué)校圖書館中查閱到的相關(guān)資料進(jìn)行數(shù)據(jù)庫的編程及實(shí)踐。
本系統(tǒng)主要由以下幾個(gè)模塊組成：(a)教師系統(tǒng)模塊（查詢、添加、修改、刪除）(b)學(xué)生系統(tǒng)模塊（查詢、添加、修改、刪除）(c)課程信息管理模塊（查詢、添加、更新、刪除）(d)成績(jī)信息管理模塊（查詢、錄入、更新、刪除）(e)班級(jí)信息管理模塊（查詢、添加、更新、刪除）(f)用戶信息管理模塊（登陸、查詢、添加、修改、刪除）



關(guān)鍵詞：信息管理系統(tǒng)；檔案管理；瀏覽器/服務(wù)器模式
The Design and Implementation of College Student Archives Management System
Abstract: The design and implementation of college student archives management information system is one of school administration system primary members.In some degree,it means that the school’s level of modernization,through the network,we can administer the information of the students across-the-board and automatizately.
College students file management system is a typical management information system(MIS).Its development mainly includes the backstage database the establishment and the maintenance as well as the onstage application procedure development two aspects. For the former requirement to establish data consistency and integrity strong, the data security good storehouse. For the latter request application function complete, easy to use. But regarding latter then the request application procedure function is complete. Easy to use and so on the characteristic.Results obtained by the investigation, I decided to use the Microsoft Corp Visual Studio 2005 in the C# language platform for the development, and the background database is based on Microsoft SQL Server 2005.In SQL Server 2005 development process, basic knowledge and basic operation for beginners we must master including the basic operation, database rights management, how to create a database table and data integrity, how to use stored procedures, views, indexes, the cursor and trigger, and a user defined data types and functions etc.
This graduation design I through to the computer hardware and software knowledge learning, to demonstrate the solutions of this system. And the schools and other areas of the investigation and analysis of system, database programming and practice according to the relevant data in the school library to refer to.
The system is mainly composed of the following modules:(a)The teacher system module (query, add, modify, delete) (b)The students in the system module (query, add, modify, delete) (c)The course information management module (query, add, update, delete) (d)The score information management module(input, query, delete) (e)The class information management module (query, add, update, delete) (f)The user information management module (login, query, add, modify, delete)

Key word: Management information system;Visual Studio 2005;Microsoft SQL Server 2005
目 錄
1 概 述 1
1.1 開發(fā)背景 1
1.2 開發(fā)意義 1
1.3 課題開發(fā)的工具及技術(shù) 2
2 可行性研究 5
2.1 技術(shù)可行性 6
2.2 經(jīng)濟(jì)可行性 6
2.3 操作可行性 6
3 大學(xué)生檔案管理系統(tǒng)需求分析 7
3.1 系統(tǒng)功能需求分析 7
3.2 系統(tǒng)功能概述 7
3.3 系統(tǒng)數(shù)據(jù)流圖 7
3.4 系統(tǒng)E-R圖設(shè)計(jì) 8
4 大學(xué)生檔案管理系統(tǒng)的總體設(shè)計(jì) 12
4.1 系統(tǒng)功能模塊描述 12
4.2 系統(tǒng)層次圖 13
4.3 數(shù)據(jù)庫設(shè)計(jì) 14
5 大學(xué)生檔案管理系統(tǒng)的詳細(xì)設(shè)計(jì) 16
5.1 系統(tǒng)登錄模塊設(shè)計(jì) 16
5.2 教師系統(tǒng)模塊設(shè)計(jì) 19
5.3 學(xué)生系統(tǒng)模塊設(shè)計(jì) 20
5.4 課程管理模塊設(shè)計(jì) 22
5.5 成績(jī)管理模塊設(shè)計(jì) 24
5.6 班級(jí)管理模塊設(shè)計(jì) 25
5.7 用戶管理模塊設(shè)計(jì) 26
6系統(tǒng)的測(cè)試與調(diào)試 28
7 結(jié)束語 29
參考文獻(xiàn) 32
致 謝 33
附 錄 34
附錄1 源程序清單 34