【正文】 2020 屆本科畢業(yè)論文 學(xué)生檔案管理系統(tǒng)的開發(fā)與設(shè)計(jì) 系 院： 學(xué)生姓名： 學(xué) 號(hào)： 專 業(yè)：計(jì)算機(jī)科學(xué)與技術(shù) 年 級(jí)： 07 級(jí) 指導(dǎo)教師： 完成日期： 2020 年 5 月 摘 要 學(xué)生 檔案管理系統(tǒng)是一個(gè)教育單位不可缺少的部分 ,它的內(nèi)容對(duì)于學(xué)校的決策者和管理者來說都至關(guān)重要 ,所以檔案管理系統(tǒng)應(yīng)該能夠?yàn)橛脩籼峁┏渥愕男畔⒑涂旖莸牟樵兪侄巍? 本系統(tǒng)能提供用戶登錄的界面使每個(gè)同學(xué)對(duì)自己的成績(jī)等各類信息進(jìn)行查詢。后臺(tái)管理平臺(tái)能夠?qū)W(xué)生的各類信息進(jìn)行插入、修 改、刪除等各種操作。同時(shí)能夠?qū)崿F(xiàn)對(duì)學(xué)生檔案信息的立即打印功能。采用 Visual C++ 作為前臺(tái)開發(fā)工具， SQL Server 2020 后臺(tái)數(shù)據(jù)處理和維護(hù)平臺(tái)，能夠?qū)γ總€(gè)模塊進(jìn)行獨(dú)立的設(shè)計(jì)和管理，為用戶提供一個(gè)方便快捷的界面。 本系統(tǒng)采用的 SQL Server 2020 數(shù)據(jù)庫后臺(tái)管理服務(wù)器有獨(dú)立的客戶端，功能十分強(qiáng)大，數(shù)據(jù)安全性高。采用 VC++作為前臺(tái)開發(fā)工具，操作簡(jiǎn)單便捷。采用了 C/S開發(fā)模式，交互性強(qiáng)能對(duì)各種錯(cuò)誤信息及時(shí)準(zhǔn)確的做出反饋。而且 C/S開發(fā)模式有很少的中間件，響應(yīng)速度快。系統(tǒng)操作界面簡(jiǎn)單大 方，系統(tǒng)功能模塊化非常方便學(xué)生各類信息的管理。實(shí)現(xiàn)過程非?？茖W(xué)，從部分高校管理系統(tǒng)的功能需求得出系統(tǒng)功能模塊圖，進(jìn)而又得出系統(tǒng)總體結(jié)構(gòu)圖，最后進(jìn)行了數(shù)據(jù)庫的詳細(xì)設(shè)計(jì)一一實(shí)現(xiàn)了各模塊功能。 關(guān)鍵詞： 管理信息系統(tǒng) 。學(xué)生 檔案管理系統(tǒng) 。關(guān)系數(shù)據(jù)庫 Abstract The school register management system management system is an education unit essential part. Its content said regarding the school policymaker and the superintendent all very important, therefore the school register management system management system should be able to provide the sufficient information and the quick inquiry method for the user. The system can provide a user interface so that each student logged the results of their inquiries and other information. Management platform to the students the background information of all kinds to insert, modify, delete and other operations. This system uses Visual c + + as a receptionist development tool and SQL Server 2020 as backend data processing and maintenance platform. Every function module was pleted smoothly .At the same time enables students to file information on the immediate printing. Each module can independently design and management, to provide users a convenient interface. This system use SQL Server 2020 as database management background server . Has independent client .The function is very strong, data security is very high. Using VC++ as a receptionist development platform, simple operation is convenient. Use the C/S developing mode, interactive to various error message strong can respond to the timely and accurate. And C/S development model between a few parts, fast response. System interface simple and easy, system function modular very convenient students all kinds of information management. Realization process is very scientific. From the part of college management system that the function demand system function module chart. Then the whole system structure, and draw the detailed design of database fulfilled each module function. Key words: The management information system。 The school register management system。 RDBM目 錄 1 緒論 .................................................................. 1 研究的背景 ........................................................ 1 國(guó)內(nèi)外研究現(xiàn)狀 .................................................... 1 問題的提出與研究的意義 ............................................ 2 本系統(tǒng)設(shè)計(jì)的目標(biāo)及功能 ............................................ 2 本系統(tǒng)設(shè)計(jì)的總體目標(biāo) .......................................... 2 系統(tǒng)的主要功能 ................................................ 2 可行性分析 ........................................................ 3 經(jīng)濟(jì)上的可行性 ................................................ 3 技術(shù)上的可行性 ................................................ 3 執(zhí)行上的可行性 ................................................ 3 論文組織 .......................................................... 4 2 開發(fā)環(huán)境和開發(fā)技術(shù) .................................................... 5 系統(tǒng)介紹 .......................................................... 5 信息系統(tǒng)簡(jiǎn)介 .................................................. 5 管理信息系統(tǒng)簡(jiǎn)介 .............................................. 6 系統(tǒng)開發(fā)模式 ...................................................... 6 系統(tǒng)開發(fā)環(huán)境 ...................................................... 8 開發(fā)環(huán)境的選擇 ................................................ 8 Visual C++ 的簡(jiǎn)介 ........................................... 8 SQL server 2020 簡(jiǎn)介 ........................................... 8 開發(fā)環(huán)境的建立 .................................................... 9 確保 SQL Server 2020 服務(wù)器正常工作 ............................ 9 測(cè) 試 SQL Server 2020 和本地服務(wù)器的連接 ........................ 9 測(cè)試 VC++和 SQL Server 2020 的連接 .............................. 9 3 需求分析 ............................................................. 10 設(shè)計(jì)思想 ......................................................... 10 需求分析 ......................................................... 10 基本功能需求 ................................................. 10 用戶界面需求 ................................................. 10 性能需求 ......................................................... 11 軟硬件需求 ................................................... 11 響應(yīng)時(shí)間 ..................................................... 11 系統(tǒng)可擴(kuò)展性 ................................................. 11 系統(tǒng)設(shè)計(jì)基礎(chǔ) ..................................................... 11 系統(tǒng)業(yè)務(wù)流程圖 ............................................... 12 系統(tǒng)數(shù)據(jù)流圖 ................................................. 12 系統(tǒng)數(shù)據(jù)字典 ..................................................... 14 數(shù)據(jù)字典簡(jiǎn)介 ................................................. 14 數(shù)據(jù)條目 ..................................................... 15 數(shù)據(jù)元素 ..................................................... 15 數(shù)據(jù)流 ....................................................... 16 數(shù)據(jù)存儲(chǔ) ..................................................... 16 4 數(shù)據(jù)庫詳細(xì)設(shè)計(jì) ....................................................... 18 數(shù)據(jù)庫設(shè)計(jì) ....................................................... 18 數(shù)據(jù)庫簡(jiǎn)介 ................................................... 18 概念 結(jié)構(gòu)設(shè)計(jì) ................................................. 18 邏輯結(jié)構(gòu)設(shè)計(jì) ................................................. 18 物理結(jié)構(gòu)設(shè)計(jì) ................................................. 21 系統(tǒng)功能模塊設(shè)計(jì) ...........