[畢業(yè)設(shè)計資料]學(xué)生宿舍管理系統(tǒng)數(shù)據(jù)庫設(shè)計_畢業(yè)資料_設(shè)計

1、信息工程學(xué)院畢業(yè)論文題目：學(xué)生宿舍管理系統(tǒng)數(shù)據(jù)庫設(shè)計姓名：專業(yè)：計算機(jī)科學(xué)與技術(shù)指導(dǎo)老師：完成日期：I目錄1.系統(tǒng)需求分析階段....................................................................................................................................11.1引言...................

2、................................................................................................................................11.2目標(biāo)與任務(wù)...................................................................................

3、....................................................11.2.1需求分析階段的目標(biāo)..........................................................................................................11.2.2需求分析階段的任務(wù)................................

4、..........................................................................11.2.3需求分析階段成果..............................................................................................................22.概念設(shè)計階段.............

5、.............................................................................................................................112.1引言........................................................................................

6、.........................................................112.2概念模型設(shè)計.................................................................................................................................122.3新系統(tǒng)流程.............

7、........................................................................................................................133邏輯設(shè)計階段...........................................................................................

8、...............................................143.1邏輯設(shè)計的任務(wù)和目標(biāo)..................................................................................................................143.2數(shù)據(jù)組織...................................

9、.......................................................................................................143.2.1將ER圖轉(zhuǎn)換為關(guān)系模型.................................................................................................14

10、3.2.2模型優(yōu)化.............................................................................................................................153.2.3數(shù)據(jù)庫模式定義........................................................................

11、.........................................163.2.4用戶子模式設(shè)計.................................................................................................................163.3數(shù)據(jù)處理...........................................

12、...............................................................................................164物理設(shè)計階段....................................................................................................................

13、......................174.1物理設(shè)計階段的目標(biāo)與任務(wù)..........................................................................................................174.2數(shù)據(jù)存儲方面................................................................

14、..................................................................174.3系統(tǒng)功能模塊..................................................................................................................................174.3.1樓道工人基本

15、的信息查詢和更新模塊............................................................................184.3.2宿舍樓基本信息的查詢和更新模塊................................................................................184.3.3宿舍基本信息的查詢和更新模塊...........

16、.........................................................................194.3.4學(xué)生基本信息的查詢和更新模塊....................................................................................204.3.5宿舍物品的查詢和更新模塊.......................

17、.....................................................................204.3.6宿舍事故的查詢和更新模塊............................................................................................214.3.7宿舍物品處理的查詢和更新模塊...................

18、.................................................................214.3.8宿舍保衛(wèi)處基本信息的查詢和更新模塊........................................................................225數(shù)據(jù)庫實施階段.................................................

19、.....................................................................................225.1建立數(shù)據(jù)庫、數(shù)據(jù)表、視圖、索引..................................................................................................225.1.1建立數(shù)據(jù)庫.....

20、...................................................................................................................225.1.2建立數(shù)據(jù)表.............................................................................................

21、...........................225.1.3建立視圖............................................................................................................................265.1.4建立索引...............................................