目 录
1 项目背景及需求分析 ..........................................................................................2
1.1 项目背景 ......................................................................................................2
1.2 需求分析 ......................................................................................................2
2 概念结构设计 ......................................................................................................2
2.1 抽象出系统实体 ..........................................................................................2
2.2 局部 E-R 图...................................................................................................2
2.3 全局 E-R 图...................................................................................................4
3 逻辑结构设计 ......................................................................................................4
3.1 初始关系模式设计 ......................................................................................4
3.2 关系模式的规范化 ......................................................................................5
4 创建数据库及相关操作 ......................................................................................5
4.1 创建数据库 .................................................................................................5
4.2 建立视图 ......................................................................................................6
4.3 建立存储过程 ..............................................................................................8
4.4 建立触发器 ..................................................................................................8
4.5 查询问题及查询结果 ..................................................................................9
5 备份和恢复的维护、安全的设置 .....................................................................12
6 项目设计心得总结 ............................................................................................12
参考文献 ................................................................................................................13
评分表....................................................................................................................14
