【正文】
ay, it is necessary to introduce efficient puter system, to assist in dealing with ticket reservation work. Therefore, development of a plete storage, query, print the ticket checking, function of realtime ticket reservation system be imperative. The design of a flight reservation management system database, according to the problem needs to design ER model, and then based on the ER model and design the corresponding relation model, for each relation model is not a relation, can design the corresponding form, then the allocation table space, create view, the design of the storage process. Key word: air ticket booking management system database ER model III 目 錄 一、緒 論 .......................................................................................................................... 1 課題簡介 .................................................................................................................... 1 設(shè)計目的 .................................................................................................................... 1 設(shè)計內(nèi)容 .................................................................................................................... 1 可行性分析 ................................................................................................................ 1 二、需求分析 .................................................................................................................... 3 需求分析的任務(wù) ......................................................................................................... 3 需求分析的過程 ......................................................................................................... 3 流程圖和數(shù)據(jù)字典 ..................................................................................................... 4 三、概念結(jié)構(gòu)設(shè)計 ............................................................................................................ 7 概念結(jié)構(gòu)設(shè)計的方法與步驟 ...................................................................................... 7 數(shù)據(jù)抽象與局部視圖設(shè)計 ......................................................................................... 7 視圖的集成 ................................................................................................................ 9 四、邏輯結(jié)構(gòu)設(shè)計 .......................................................................................................... 11 ER 圖向關(guān)系模型的轉(zhuǎn)換 ......................................................................................... 11 關(guān)系模式優(yōu)化 ........................................................................................................... 11 五、數(shù)據(jù)庫物理設(shè)計 ...................................................................................................... 13 表的建立 ...................................................................................................................13 視圖的建立 ...............................................................................................................14 索引的建立 ...............................................................................................................15 六、數(shù)據(jù)庫的實施 .......................................................................................................... 17 數(shù)據(jù)庫的安排 ...........................................................................................................17 數(shù)據(jù)庫的運行 ................