【正文】 學(xué)位論文 學(xué)生管理系統(tǒng)的設(shè)計與實 現(xiàn) 論文作者姓名： 申請學(xué)位專業(yè)： 申請學(xué)位類別： 指導(dǎo)教師姓名（職稱）： 論文提交日期： I 學(xué)生管理系統(tǒng)的設(shè)計與實 現(xiàn) 摘 要 隨著信息處理技術(shù)的飛速發(fā)展 ,基于計算機網(wǎng)絡(luò)的信息處理系統(tǒng)已成為人們?nèi)粘９ぷ?,學(xué)習(xí)和生活必備系統(tǒng) 。 在 Inter 飛速發(fā)展的今天 ,互聯(lián)網(wǎng)已成為人們快速獲取 ,發(fā)布和傳遞信息的重要渠道 ,它已成為社會生活的一部分 。 學(xué)生信息處理的電腦化 ， 網(wǎng)絡(luò)化 ,是實現(xiàn)學(xué)校管理現(xiàn)代化和信息化的重要內(nèi)容 ,也是方便用戶快捷查詢相關(guān)充足信息的重要 工具 。 與傳統(tǒng)學(xué)生信息處理模式相比 ,基于網(wǎng)絡(luò)的學(xué)生管理系統(tǒng)具有無可比擬的優(yōu)越性 。 本系統(tǒng)是利用 Visual Basic 程序設(shè)計語言及 Access 2021 數(shù)據(jù)庫進行設(shè)計與開發(fā)的一個簡單的學(xué)生管理系統(tǒng)。本文首先對學(xué)生信息管理系統(tǒng)進行較詳細的需求分析 ,并給出系統(tǒng)總體架構(gòu)及詳細設(shè)計步驟 ?這個系統(tǒng)主要包括系統(tǒng)進入界面、用戶登錄界面、信息管理（主界面）、學(xué)籍管理、班級管理以及退出系統(tǒng)等模塊，主要功能包括學(xué)生信息的添加 ,修改 ,刪除，查詢等功能 ?該系統(tǒng)的開發(fā)目的是利用計算機管理學(xué)生的學(xué)籍信息，它具有友好的用戶界面、檢索速度 快、查找方便、容易修改、存儲量大、數(shù)據(jù)處理快捷、保密性好、壽命長以及成本低等。 關(guān)鍵詞：學(xué)生管理系統(tǒng) Visual Basic 數(shù)據(jù)庫 信息查詢 表單 Access II Student management system design and implementation Abstract Along with the rapid development of information processing technology, information management system, which is based on puter work, has bee a necessity system in routine work, study and life. With the rapid development of the Inter, today the Inter has bee an important channel for fast gaining, issuing and transmitting information, and obviously it has been an essential part of our social life. Computerization and work station of student information processing are important for realizing modernization and information of school administration, and it also is an important way for searching sufficient information of users. Compared with the traditional pattern, student management system based on the Inter has inparable superiority. This system is the use of Visual Basic programming language and the Access 2021 database design and development of a simple student management system. This paper first carries on a detailed demand analysis to the student information management system, and then gives the overall construction and the detailed design procedure. the system access interface, the user login interface, information management ( main form ), school management , class management and exit the system are included in this system. Its main functions include student information statistics, adding, modifying, deletion, inquiry and so on. The purpose of the system is to manage student information with puter, such as friendly user interface, search quickly, easy to query and modify, larger storage capacity, higher dataprocessing speed, good privacy, long life and low cost and so on. Keywords： Student Management System ； Visual Basic ； DataBase ； Information Inquiry ； form 。Access III 目 錄 1 學(xué)生管理系統(tǒng)的概述 .................................................................. 1 選題的意義 .................................................................... 1 可行性分析 .................................................................... 2 社會與經(jīng)濟可行性分析 .................................................... 2 技術(shù)可行性分析 .......................................................... 2 操作可行性分析 .......................................................... 3 開發(fā)環(huán)境分析 ............................................................ 3 2 開發(fā)工具的介紹 ...................................................................... 3 VB開發(fā)環(huán)境的特點 ............................................................. 3 數(shù)據(jù)庫基本概念與 Microsoft Access .............................................. 5 數(shù)據(jù)管理技術(shù)發(fā)展過程 .................................................... 5 數(shù)據(jù)庫系統(tǒng)簡介 .......................................................... 6 數(shù)據(jù)庫設(shè)計基礎(chǔ) ................................................................ 7 數(shù)據(jù)庫設(shè)計的規(guī)范化 ...................................................... 7 數(shù)據(jù)庫設(shè)計的步驟 ........................................................ 8 數(shù)據(jù)管理系統(tǒng) Access概述 ....................................................... 8 Access的基本特點 ....................................................... 8 Access的基本對象 ....................................................... 8 使用 VB數(shù)據(jù)庫開發(fā)技術(shù) ......................................................... 9 ADO對象模型 ............................................................ 9 使用 ADO數(shù)據(jù)控件 ........................................................ 9 使用 ADO訪問數(shù)據(jù)庫 ..................................................... 10 SQL語言 ............................................................... 13 3 需求分析與數(shù)據(jù)庫設(shè)計 ............................................................... 15 需求分析 ..................................................................... 15 需求分析的原則 ......................................................... 15 用戶需求分析及系統(tǒng) 性能需求分析 ......................................... 16 系統(tǒng)總體設(shè)計框架圖 ........................................................... 16 數(shù)據(jù)庫的設(shè)計 ................................................................. 19 系統(tǒng)數(shù)據(jù)流分析 ......................................................... 19 實體 ER圖分析 ......................................................... 20 數(shù)據(jù)庫邏輯設(shè)計 ......................................................... 22 數(shù)據(jù)表間關(guān)系 ........................................................... 23 4學(xué)生管理系統(tǒng)的實現(xiàn) ................................................................. 24 ................................................................. 24 ........................................................... 25 ........................................................... 25 ........................................................... 29 ........................................................... 29 結(jié) 論 ............................................................................ 33 參考文獻 ............................................................................ 34 致 謝 ............................................................................ 35 聲 明 ............................................................................ 36 第 1 頁 共 36 頁 1 學(xué)生管理系統(tǒng)的概述 選題的意義 隨著中國信息化的加速發(fā)展，位于教育前沿的學(xué)校在辦公自動化上也加