目录第一章前言..................................................................................................................1第二章数据库设计需求分析和系统设计..................................................................21.1需求分析...................................................................................................21.2任务概述...................................................................................................31.2.1目标.................................................................................................31.2.2运行环境.........................................................................................31.3数据字典...................................................................................................41.3.1数据项.............................................................................................41.3.2数据结构.........................................................................................41.33数据流..............................................................................................41.3.4数据存储.........................................................................................41.3.5处理过程.........................................................................................51.4数据流图...................................................................................................6第三章概念结构设计..................................................................................................73.1概念结构...................................................................................................73.2酒店管理系统概念结构设计...................................................................73.2.1系统实体E-R图.............................................................................83.2.2酒店管理系统系统E-R图...........................................................10第四章逻辑结构设计................................................................................................114.1E-R图向关系模式的转换......................................................................114.2关系模式的规范化.................................................................................124.2.1分析并规范化现有的关系模式...................................................124.2.2确定完整性约束...........................................................................124.2.3用户视图的确定...........................................................................13第五章物理设计........................................................................................................145.1确定数据分布.........................................................................................145.2确定数据存储结构.................................................................................145.3基本表设计.............................................................................................15I5.3.1餐台表...........................................................................................155.3.2菜系表...........................................................................................155.3.3菜品信息表...................................................................................165.3.4消费单..............................................................................
