【正文】 ers and students time efficiently. It is to improve the efficiency, not only by teachers` effects, not only by students` effects, not only by staff`s effects, but also with wellanized management system, but also with Ao Tong Online Web Test. Because Ao Tong Online Web Test is a typical information management system, which develops establishes, and maintains backstage database by consistency and integrality and FrontPrograms easilyused. In cyber world today, Ao Tong Online Test Web has paperless exam achieved possibly. Ao Tong Online Web Test is a typically database applied program, consisting of students information management, teachers information management, paper test information management, categories information management, results information management, administrator information maintaining and so on. By analysis, we use the Microsoft Visual Studio 20xx as a development tool, and ASP language, SQL SERVER 20xx as backstage data. It is develop based on B/S service mode work have an examination system .We use the Microsoft Visual Studio 20xx and SQL SERVER 20xx to finish the development of Ao Tong Online Web Test. Key words： data base； SQL SERVER20xx； Ao Tong Online Web Test； ASP 遼寧科技大學(xué)本科 生 畢業(yè)設(shè)計（論文） 第 III 頁 目錄 1 緒論 ........................................................................................................... 1 選題背景 .............................................................................................................................. 1 課題來源及意義 .................................................................................................................. 3 系統(tǒng)基本達(dá)到的目標(biāo)和結(jié)論 .............................................................................................. 3 開發(fā)工具和數(shù)據(jù)庫的選擇 .................................................................................................. 4 2 系統(tǒng)需求分 析 ............................................................................................ 6 可行性分析 .......................................................................................................................... 6 技術(shù)可行性 ....................................................................................................................... 6 經(jīng)濟(jì)可行性 ....................................................................................................................... 7 操作可行性 ....................................................................................................................... 7 社會可行性 ....................................................................................................................... 7 軟、硬件配置及設(shè)計方法 .................................................................................................. 8 硬件配置 ........................................................................................................................... 8 設(shè)計方法 ........................................................................................................................... 8 系統(tǒng)規(guī)劃 ........................................................................................................................... 9 系統(tǒng)數(shù)據(jù)流圖的創(chuàng)建 .......................................................................................................... 9 業(yè)務(wù)流程圖 .......................................................................................................................... 9 數(shù)據(jù)字典的創(chuàng)建 ................................................................................................................ 11 3 系統(tǒng)概要設(shè)計 ...........................................................................................13 系統(tǒng)功能模塊設(shè)計 ............................................................................................................ 13 系統(tǒng)功能設(shè)計 ................................................................................................................. 13 模塊設(shè)計 ......................................................................................................................... 13 數(shù)據(jù)庫概要設(shè)計 ................................................................................................................ 17 遼寧科技大學(xué)本科 生 畢業(yè)設(shè)計（論文） 第 IV 頁 數(shù)據(jù)庫概要設(shè)計主要任務(wù) ............................................................................................. 17 ER圖設(shè)計 ............................................................................................................. 17 ER圖轉(zhuǎn)換成關(guān)系模型 .................................................................................................. 21 數(shù)據(jù)模型的優(yōu)化 ............................................................................................................. 22 數(shù)據(jù)庫的物理實現(xiàn) ............................................................................................................ 22 數(shù)據(jù)庫的物理設(shè)計的內(nèi)容和方法 ................................................................................. 22 數(shù)據(jù)庫表的創(chuàng)建 ............................................................................................................. 23 4 系統(tǒng)詳細(xì)設(shè)計 ...........................................................................................26 用戶登入模塊 .................................................................................................................... 26 學(xué)生基本信息模塊 ............................................................................................................. 28 教師基本信息模塊 ............................................................................................................ 29 試題基本信息模塊 ............................................................................................................ 30 考試科目設(shè)置模塊 ............................................................................................................ 31 考試結(jié)果模塊 ..........................................................................................................