【正文】
查詢學生情況 學生情況 查詢要求 數據文件 考試錄取情況 準考證、座位條 通知書和報表 考 試 錄 打印要求 數據文件 取 情 打印 況 .1查詢類型處理 詢 證書、安排和報表處理 打印類型處理 準考證考場安排座位條報表 庫 2層數據流圖 2層數據流圖 ER 圖 概念結構設計是整個數據庫設計的關鍵所在,設計概念結構一般有四類方法,但無論采用哪種設計方法,一般都以 ER 模型為工具來描述概念結構。 PB 數據管道技術實現(xiàn)了在不同數據庫表之間移動數據的功能,既可以作為實用工具以交互方式作用,也可以嵌入應用程序中動態(tài)調用執(zhí)行,而后者正是數據庫管理系統(tǒng)( DBMS)所不具備的功能。 用戶平臺要求 系統(tǒng)主要用于山西農業(yè)大學的局域網,服務器端使用教務處自己的服務器;用戶端在 Win9 Win2020 、 WinXP 等環(huán)境下均可使用。 ( 1)實現(xiàn)高校招生管理工作的自動化,減少繁重的體力勞動,提高工作效率。 1 需求分析 需求分析簡單的說就是分析用戶的需要與要求。s pressure and improve production efficiency . In system analysis, it makes analysis of the business that is superficial and deep one source of data with going to and system function and the system at economy, technology and society factor feasibilities of respect of three pieces. System design in detail includes several parts : control module , examination management module , system maintain module and main window body and pass window design of examination management module , according to admission card number for entrance examination that input , through calculating the remainder and fetching and exactly making operation, it can go out of examination hall No. and seat No. For instance, admission card No. for entrance examination is 2020000099, assume each examination hall has 30 examinee , as follows, 2020000099mod100=99, 99mod30=9,99\30 =3, the examination hall No. is 3+1 =4, the number of the seat is 9+1 =10. In addition, it only need design the report form in VB if we want to type the examination hall arrangement and the seat paper. The design of the relation database is mainly the choice of the database and the design of data list. The database has adopted Access2020 database that Microsoft put out . Microsoft Access is a relation database developing instrument, and the relation database is one of the most mon databases that have been already developed . Access can gather various kinds of information for inquiring about , storage and search. It can possess convenience of desk datebase and strong function of relation database in a date bag. In the design of the data list , it builds five basic forms together , and has expressed its physics structure in the form of form. The system has characteristics of highefficient , easy to maintain and use etc, and the structure of system is clear, the interface is friendly, has multiple functions, can reduce work load effectively and improve the efficiency of management of enrolling new students . Key words:Enrollment administrative system; Management information system; Relation database 目錄 引言1 1 需求分析1 招 生 管 理 現(xiàn) 狀1 用戶需求1 發(fā) 展 趨 勢 需 求 分 析2 2 系統(tǒng)分析3 業(yè) 務 流 程 分 析3 數據流圖4 ER 圖6 功能分析7 系 統(tǒng) 設 計 原 則7 系統(tǒng)可行性分析8 3 概要設計9 系統(tǒng)功能結構圖9 數 據 庫 的 設 計10 開 發(fā) 運 行 環(huán) 境 和 工 具分析10 4 詳細設計11 考試管理 模 塊 設 計 與 實 現(xiàn)11 系統(tǒng) 的 數 據 庫 的 設 計16 5 問題 分析18 6 結束語19 參考文獻20 致謝21 引言 進入 21 世紀以來,經濟全球化的趨勢加速,現(xiàn)代科學技術突飛猛進,市場競爭更加劇烈,人類面臨著巨大的社會經濟變革。 Microsoft Access是關系數據庫開發(fā)工具,而關系數據庫是已開發(fā)的最通用的數據庫之一。在需求分析中,從用戶的切身利益、對現(xiàn)有招生管理工作弊端的分析以及發(fā)展趨勢和需求的產生的相互作用的角度,著眼于減輕工作人員壓力和提高生產效率,提出系統(tǒng)功能設計要求。系統(tǒng)分析主要包括業(yè)務流程分析、數據流圖分析、 E— R 圖分析和功能分析等六個內容。 數據庫采用了 Microsoft推出的 Access2020數據庫 。s needs analysis and demand analysis of the development trend. System analysis mainly includes six contents that are business procedure analysis , dataflow picture analysis , ER picture analysis and function analysis , etc.. In the demand analysis,