【正文】 ......................................................................................................................................................2 需求分析階段的目標(biāo) ..........................................................................................................................................2 需求分析階段的任務(wù) ..........................................................................................................................................2 處理對(duì)象： ..................................................................................................................................................2 處理功能及要求： .......................................................................................................................................2 需求分析階段成果 .............................................................................................................................................3 體會(huì)與收獲 ..................................................................................................................................................3 酒店客房管理系統(tǒng)業(yè)務(wù)流程圖和數(shù)據(jù)流圖（見附錄 1） ....................................................................3 酒店客房管理系統(tǒng)數(shù)據(jù)字典 .....................................................................................................................3 3 概念設(shè)計(jì)階段 .............................................................................................................................................................4 概念設(shè)計(jì)階段的任務(wù)和目標(biāo) .............................................................................................................................4 階段結(jié)果 ..............................................................................................................................................................4 4 邏輯設(shè)計(jì)階段 .............................................................................................................................................................6 邏輯設(shè)計(jì)的任務(wù)和目標(biāo) .....................................................................................................................................6 數(shù)據(jù)組織 ..............................................................................................................................................................6 將 ER 圖轉(zhuǎn)換為關(guān)系模型 .........................................................................................................................6 模型優(yōu)化 ......................................................................................................................................................7 數(shù)據(jù)庫模式定義 ...........................................................................................................................................7 用戶子模式定義 ...........................................................................................................................................7 5 物理設(shè)計(jì)階段 ..............................................................................................................................................................8 物理設(shè)計(jì)階段的目標(biāo)與任務(wù) .............................................................................................................................8 系統(tǒng)功能模塊圖 ..................................................................................................................................................8 程序流程圖 ...........................................................................................................................................................8 6 實(shí)施階段 .................................................................................................................................................................. 10 建立數(shù)據(jù)庫、數(shù)據(jù)表、視圖 .......................................................................................................................... 10 建立數(shù)據(jù)庫 ............................................................................................................................................... 10 建立數(shù)據(jù)表（具體 SQL 語句見附錄 ） .......................................................................................... 10 建立視圖（具體 SQL 語句見附錄 ） ............................................................................................... 10 建立存儲(chǔ)過程（具體 SQL 語句見附錄 ） ....................................................................................... 10 建立觸發(fā)器（具體 SQL 語句見附錄 ） ............................................................................................11 數(shù)據(jù)入庫 .............................................................................................................................................................11 II 7 系統(tǒng)調(diào)試、測(cè)試 ........................................................................................................................................................11 8 心得體會(huì) ....................................................................................................................................................................11 9 存在的問題及建議 ................................................................................................................................................... 12 致謝 ............................................................................................................................................................................... 13 參考文獻(xiàn) ...................................................................................................................................................................... 13 附錄 1 酒店客房管理系統(tǒng)業(yè)務(wù)流程圖和數(shù)據(jù)流圖 .............................................................................................. 14 ........................................................................................................................................................... 14 ............................................................................................................................................................... 16 附錄 2 數(shù)據(jù)字典