![](https://csdnimg.cn/release/download_crawler_static/87964615/bg2.jpg)
11 级信息管理与信息系统专业 2 班数据库应用系统课程设计课程论文
目录
《数据库课程设计》论文 ...........................................................................................................1
1.需求分析 ................................................................................................................................2
1.1 处理对象及组织 .............................................................................................................2
1.2 信息处理及系统功能......................................................................................................3
1.3 数据库系统性能需要......................................................................................................3
1.4 数据库系统开发环境需求 ..............................................................................................3
1.5 需求分析阶段成果展示 ..................................................................................................3
1.5.1 数据流程图 ..........................................................................................................3
1.5.2 数据字典 ..............................................................................................................6
1.5.3 数据结构 ..............................................................................................................8
1.5.4 数据流 ..................................................................................................................9
1.5.5 数据存储 ............................................................................................................10
1.5.6 处理过程 ............................................................................................................11
2.数据库结构设计 ...................................................................................................................12
2.1 概念设计......................................................................................................................12
2.1.1 分 E-R 图建立 ...................................................................................................12
2.1.2 全局/整体 E-R 图 ..............................................................................................15
2.2 逻辑设计......................................................................................................................15
2.2.1 建立关系模式....................................................................................................16
2.2.2 关系模式规范化处理 ........................................................................................16
2.2.3 用户子模式建立 ................................................................................................16
2.2.4 关系模式逻辑结构定义 ....................................................................................18
3. 数据库物理设计 .................................................................................................................19
4.数据库实施与测试 ...............................................................................................................19
4.1 数据库实施 ..................................................................................................................19
4.1.1 数据库及数据库对象建立 .................................................................................19
4.1.2 数据入库 ...........................................................................................................19
4.2 数据库测试 ..................................................................................................................19
5.总结 ......................................................................................................................................20
6.附录 ......................................................................................................................................21
6.1 附录 1 (书店进销存系统)关系模式汇总 ..............................................................21
6.2 附录 2 数据定义语句 ............................................................................................23
6.2.1 SQL SERVER 2008 中对基本表的创建 .............................................................23
6.2.2 SQL SERVER 2008 中对基本表的增删改 .........................................................25
6.2.3 SQL SERVER 2008 中视图的创建.....................................................................28
6.2.4 SQL SERVER 2008 中存储过程的创建 .............................................................34
6.2.5 SQL SERVER 2008 中触发器的创建 .................................................................36
6.3 附录 3 ORCl 下数据操纵验证 ......................................................................................42