题目：点菜管理信息系统
目录
引言 ..................................................................................................................................................2
1 内容及要求 ...........................................................................................................................2
2 系统环境选择 .......................................................................................................................2
一、需求分析 ..................................................................................................................................2
1.1 设计背景 ............................................................................................................................2
1.2 功能分析 ............................................................................................................................3
信息要求：.......................................................................................................................3
处理要求：.......................................................................................................................3
1.3 数据分析 ...........................................................................................................................3
数据项： ..........................................................................................................................3
数据结构：.......................................................................................................................5
1.4 安全性与完整性................................................................................................................5
安全性要求：...................................................................................................................5
完整性要求：...................................................................................................................6
二、概念结构设计 ..........................................................................................................................7
2.1 实体属性 ...........................................................................................................................7
2.2 实体联系 ...........................................................................................................................7
2.3 数据库设计图 ...................................................................................................................8
三、逻辑结构设计 ..........................................................................................................................9
3.1 关系模型 ............................................................................................................................9
3.2 表格 ....................................................................................................................................9
3.3 触发器与过程 ..................................................................................................................12
3.4 视图 ..................................................................................................................................13
四、物理结构设计 ........................................................................................................................13
五、功能设计 ................................................................................................................................14
5.1 核心功能流程.................................................................................................................14
5.2 功能模块 ........................................................................................................................15
六、系统实现 ................................................................................................................................16
6.1 登录页面 .........................................................................................................................16
6.2 点菜页面 .........................................................................................................................16
6.3 订单提交页面..................................................................................................................18
6.4 普通员工功能..................................................................................................................21
6.5 管理员功能 .....................................................................................................................26
七、心得体会 ................................................................................................................................33
参考文献 ........................................................................................................................................34
