高校圖書館管理系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)資料

1、圖書管理系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)學(xué)號(hào)：專業(yè)班級(jí)：姓名：指導(dǎo)老師：完成日期：目錄1引言............................................................................................................................................................12.需求分析階段..................

2、........................................................................................................................22.1引言..............................................................................................

3、.....................................................22.2需求分析階段的目標(biāo)與任務(wù)...........................................................................................................22.2.1處理對(duì)象..................................

4、.....................................................................................22.2.2處理功能及要求...........................................................................................................32.2.3.安全性和完整性要

5、求..................................................................................................32.3需求分析階段成果.............................................................................................................

6、..............33概念設(shè)計(jì)階段............................................................................................................................................93.1引言....................................................

7、...............................................................................................93.2任務(wù)與目標(biāo)....................................................................................................................

8、.................103.3階段結(jié)果.........................................................................................................................................104邏輯設(shè)計(jì)階段................................................

9、..........................................................................................124.1邏輯設(shè)計(jì)的任務(wù)和目標(biāo)..................................................................................................................1

10、24.2數(shù)據(jù)組織..........................................................................................................................................124.2.1將ER圖轉(zhuǎn)換為關(guān)系模型........................................................

11、.........................................124.2.2模型優(yōu)化.............................................................................................................................134.2.3數(shù)據(jù)庫模式定義.............................

12、....................................................................................134.2.4用戶子模式定義................................................................................................................154.3數(shù)據(jù)處理.

13、.........................................................................................................................................165物理設(shè)計(jì)階段..........................................................................

14、................................................................175.1物理設(shè)計(jì)階段的目標(biāo)與任務(wù)..........................................................................................................175.2數(shù)據(jù)存儲(chǔ)方面......................

15、............................................................................................................175.3系統(tǒng)功能模塊.....................................................................................................

16、.............................175.3.1讀者基本信息的查詢和更新模塊....................................................................................175.3.2圖書基本信息的查詢和更新模塊.................................................................

17、...................186數(shù)據(jù)庫實(shí)施階段......................................................................................................................................196.1建立數(shù)據(jù)庫、數(shù)據(jù)表、視圖、索引.....................................

18、.............................................................196.1.1建立數(shù)據(jù)庫........................................................................................................................196.1.2建立數(shù)據(jù)表...............

19、.........................................................................................................196.1.3建立視圖........................................................................................................

20、....................216.1.4建立索引............................................................................................................................216.1.5建立觸發(fā)器.....................................................

21、...................................................................226.2數(shù)據(jù)入庫..........................................................................................................................................226.3創(chuàng)

22、建各個(gè)功能的存儲(chǔ)過程..............................................................................................................227系統(tǒng)調(diào)試和測(cè)試..........................................................................................