【正文】 畢業(yè)設(shè)計 ( 論文 ) 考試題庫管理系統(tǒng)的設(shè)計與實(shí)現(xiàn) 論文作者姓名： 申請學(xué)位專業(yè)： 申請學(xué)位類別： 指導(dǎo)教師姓名（職稱）： 論文提交日期： 考試題庫管理系統(tǒng)的 設(shè)計與實(shí)現(xiàn) 摘 要 在傳統(tǒng)的試題管理工作中，主要采用人工方式，不利于現(xiàn)代教學(xué)的管理，主要表現(xiàn)在試題存儲分散，試題歸類麻煩和試卷生成不靈活等缺點(diǎn)，因此，以計算機(jī)管理的 考試題庫系統(tǒng)克服了傳統(tǒng)人工的缺點(diǎn)。 該系統(tǒng) 利 用 技術(shù)，結(jié)合 SQL Sever 2021 數(shù)據(jù)庫開發(fā)和設(shè)計， 提供按用戶角色方式實(shí)現(xiàn)試題的錄 入、修改和試題輸出（生成試卷）的管理。該系統(tǒng)可以對用戶所操作的模塊和功能進(jìn)行管理；可以對試題的輸入和輸出進(jìn)行管理；可以添加系，并在系內(nèi)添加專業(yè)和課程的分類管理；實(shí)現(xiàn)了教師添加試題，需教務(wù)科和系審批試題的操作。本 系統(tǒng)的獨(dú)特之處就在于試題審批模塊。經(jīng)過對本系統(tǒng)的測試后， 功能基本可以滿足教師日常試卷管理的需要。如果進(jìn)一步詳細(xì)設(shè)計系統(tǒng)后，可以作為一個更專業(yè)化的試題管理教學(xué)平臺。 關(guān)鍵詞 ： 試題權(quán)限；審批； ； SQL Server Design and Implementation of Management System of Test Questions Base Abstract In the traditional management work of the exam paper, always take the way of handwork, which doesn’t benefit the modern teaching management because of its disadvantages, including the dispersive storage of test questions, fussy rank of test questions and the formalistic style of test questions. The test questions base system designs based on the puter theory makes up these disadvantages. The base makes the use of technique and integrates the exploitation and design of SQL Server 2021 to provide a procedure to form a paper. The procedure is corresponded to the each customer to input, edit and output the test questions. The system enables us to manage the module and the function operated by the clients. Additionally, we can add the department in the system and manage the different part according to the specialty and the course. Adopt the system, we can add the test questions by teachers and examine and approve the test questions by the educational administration branch and the department. The particular character of the system is the module of examine and approves the test Being tested, the system almost enables the teachers’ daily work of managing the exam paper. Given a further design, the system could be regarded as a much more professional teaching flat to manage the test question. Key words: the Examination Permissions。 Auditing。 。 SQL Server 目 錄 論文總頁數(shù)： 22 頁 1 引言 .......................................................................................................................... 1 選題背景 ........................................................................................................... 1 系統(tǒng)特點(diǎn) ........................................................................................................... 1 2 考試題庫管理系統(tǒng)功能分析 ....................................................................................... 1 用戶和用戶角色管理 ......................................................................................... 2 試題錄入管理 .................................................................................................... 2 試題輸出管理 .................................................................................................... 3 專業(yè)分類管理 .................................................................................................... 3 課程分類管理 .................................................................................................... 3 3 考試 題庫管理系統(tǒng)分析和設(shè)計 ................................................................................... 3 系統(tǒng)模塊設(shè)計 .................................................................................................... 3 用戶登錄模塊 .................................................................................................... 3 管理模塊 ........................................................................................................... 4 自動組卷模塊 .................................................................................................... 4 審批模塊 ........................................................................................................... 4 重新登錄 ........................................................................................................... 4 4 考試題庫管理系統(tǒng)數(shù)據(jù)庫設(shè)計 ................................................................................... 4 用戶表 .............................................................................................................. 5 角色表 .............................................................................................................. 5 課程表 .............................................................................................................. 5 單位表 .............................................................................................................. 5 試題表 .............................................................................................................. 5 審批表 .............................................................................................................. 6 5 系統(tǒng)詳細(xì)設(shè)計 ............................................................................................................ 6 系統(tǒng)首頁面 ....................................................................................................... 6 管理員登錄后頁面 ............................................................................................. 8 教務(wù)科 登錄后頁面 ............................................................................................. 8 系管理員登錄后頁面 ......................................................................................... 9 教師登錄后頁面 ................................................................................................ 9 添加用戶頁 面 .................................................................................................. 10 添加課程和題型頁面 ....................................................................................... 11 試題添加頁面 .................................................................................................. 12 生成試卷 ......................................................................................................... 13 試題審批 .........................................................................................