論文標(biāo)準(zhǔn)WORD格式排版 共24頁

摘要： 圖書信息管理系統(tǒng)主要由讀者信息管理模塊，圖書信息管理模塊，借閱信息管理模塊，系統(tǒng)信息管理模塊等組成。其中又各自分成讀者注冊，證件修改，用戶注銷，圖書查詢，操作記錄等子模塊。在設(shè)計(jì)本系統(tǒng)過程中，我們第一步由自頂而下的需求分析概括設(shè)計(jì)出系統(tǒng)總模塊的數(shù)據(jù)流圖，再設(shè)計(jì)個(gè)子模塊的相應(yīng)數(shù)據(jù)流圖，列出數(shù)據(jù)流信息及數(shù)據(jù)字典；第二步概念設(shè)計(jì)在需求分析基礎(chǔ)上用E-R圖表示出數(shù)據(jù)及相互間聯(lián)系，采用先作子圖，再合并成初步E-R圖，進(jìn)行修改和重構(gòu)后得到基本E-R圖；第三步邏輯設(shè)計(jì)，在SQL Server的設(shè)計(jì)環(huán)境下把圖書館管理系統(tǒng)E-R圖轉(zhuǎn)化為成邏輯數(shù)據(jù)模型表示的邏輯模式，同時(shí)實(shí)現(xiàn)數(shù)據(jù)模型的優(yōu)化和數(shù)據(jù)模式的規(guī)范化；第四步進(jìn)行物理設(shè)計(jì)設(shè)計(jì)數(shù)據(jù)的內(nèi)模式，確定數(shù)據(jù)的存儲(chǔ)結(jié)構(gòu)，存取路徑，存儲(chǔ)空間分配等等，具體形式為表，視圖，索引的建立。

關(guān)鍵字：數(shù)據(jù)庫，SQL語言，MS SQL Server，圖書管理

Abstract：The books information management system mainly by the reader information management module, the books information management module, borrows the information management module, the system information management module and so on is composed.Respectively divides into the reader registration, the credential revises, the user cancels, books inquiry, operating record small steelyard module. In designs in this system process, we first step by from go against but the under demand analysis summary to design the system total module the data stream chart, the re-engineering stature module corresponding data stream chart, lists the data stream information and the data dictionary;The second step of conceptual design expressed in the demand analysis foundation with the E-R chart the data and mutually relates, uses first is the child to attempt, then merges the preliminary E-R chart, after carries on the revision and the heavy construction obtains basic E-R; The third step of logical design, transforms in under the SQL Server design environment the library management system E-R chart for becomes the logic data model expression the logical pattern, simultaneously realizes the data model optimization and the data pattern standard is deficient; Fourth step carries on the physical design design data in pattern, the specified data memory structure, the access path, storage space assignment and so on, the concrete form is the table, the view, the index constructs

Keywords:DataBase,SQL Language,MS SQL Server, Books management
....