【正文】 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è)計(jì)（論文） 第 III 頁(yè) 目錄 1 緒論 ........................................................................................................... 1 選題背景 .............................................................................................................................. 1 課題來(lái)源及意義 .................................................................................................................. 3 系統(tǒng)基本達(dá)到的目標(biāo)和結(jié)論 .............................................................................................. 3 開(kāi)發(fā)工具和數(shù)據(jù)庫(kù)的選擇 .................................................................................................. 4 2 系統(tǒng)需求分 析 ............................................................................................ 6 可行性分析 .......................................................................................................................... 6 技術(shù)可行性 ....................................................................................................................... 6 經(jīng)濟(jì)可行性 ....................................................................................................................... 7 操作可行性 ....................................................................................................................... 7 社會(huì)可行性 ....................................................................................................................... 7 軟、硬件配置及設(shè)計(jì)方法 .................................................................................................. 8 硬件配置 ........................................................................................................................... 8 設(shè)計(jì)方法 ........................................................................................................................... 8 系統(tǒng)規(guī)劃 ........................................................................................................................... 9 系統(tǒng)數(shù)據(jù)流圖的創(chuàng)建 .......................................................................................................... 9 業(yè)務(wù)流程圖 .......................................................................................................................... 9 數(shù)據(jù)字典的創(chuàng)建 ................................................................................................................ 11 3 系統(tǒng)概要設(shè)計(jì) ...........................................................................................13 系統(tǒng)功能模塊設(shè)計(jì) ............................................................................................................ 13 系統(tǒng)功能設(shè)計(jì) ................................................................................................................. 13 模塊設(shè)計(jì) ......................................................................................................................... 13 數(shù)據(jù)庫(kù)概要設(shè)計(jì) ................................................................................................................ 17 遼寧科技大學(xué)本科 生 畢業(yè)設(shè)計(jì)（論文） 第 IV 頁(yè) 數(shù)據(jù)庫(kù)概要設(shè)計(jì)主要任務(wù) ............................................................................................. 17 ER圖設(shè)計(jì) ............................................................................................................. 17 ER圖轉(zhuǎn)換成關(guān)系模型 .................................................................................................. 21 數(shù)據(jù)模型的優(yōu)化 ............................................................................................................. 22 數(shù)據(jù)庫(kù)的物理實(shí)現(xiàn) ............................................................................................................ 22 數(shù)據(jù)庫(kù)的物理設(shè)計(jì)的內(nèi)容和方法 ................................................................................. 22 數(shù)據(jù)庫(kù)表的創(chuàng)建 ............................................................................................................. 23 4 系統(tǒng)詳細(xì)設(shè)計(jì) ...........................................................................................26 用戶登入模塊 .................................................................................................................... 26 學(xué)生基本信息模塊 ............................................................................................................. 28 教師基本信息模塊 ............................................................................................................ 29 試題基本信息模塊 ............................................................................................................ 30 考試科目設(shè)置模塊 ............................................................................................................ 31 考試結(jié)果模塊 ..........................................................................................................