目 录
1 需求分析 .............................................................................................................1
1.1 数据事实 ...................................................................................................1
1.2 主要用户视图 ...........................................................................................2
2 概念结构设计 .....................................................................................................2
2.1 局部 ER 图 ................................................................................................2
2.2 全局 ER 图 ................................................................................................3
3 逻辑结构设计 .....................................................................................................3
4 物理结构设计 .....................................................................................................4
5 主要功能详细设计 .............................................................................................5
5.1 添加数据 .......................................................................................................5
5.2 创建索引 .......................................................................................................5
5.3 函数 ...............................................................................................................6
5.4 存储过程 .......................................................................................................8
5.5 触发器 .........................................................................................................12
5.6 函数 .............................................................................................................15
5.7 视图 .............................................................................................................16