《数据库原理与应用》课程设计论文 ..........................................................................................................1
1.系统需求分析 ...............................................................................................................................................1
1.1 引言 ...................................................................................................................................................1
1.2 目标与任务 .......................................................................................................................................1
1.2.1 需求分析阶段的目标 .............................................................................................................1
1.2.2 需求分析阶段的任务 .............................................................................................................1
2. 概念设计 ..................................................................................................................................................6
2.1 概念设计任务 ...................................................................................................................................6
2.2 概念模型设计 ...................................................................................................................................6
3. 逻辑设计 ..................................................................................................................................................7
3.1 逻辑设计的目标和任务 ...................................................................................................................7
3.2 关系模型设计 ...................................................................................................................................7
3.2.1 ER 转化关系模型...................................................................................................................7
3.2.2 关系模型优化 .........................................................................................................................9
3.2.3 用户子模式设计 ...................................................................................................................10
3.3 数据处理 .........................................................................................................................................10
4. 物理设计 ................................................................................................................................................10
4.1 物理设计目标与任务 .....................................................................................................................10
4.2 物理存储 .........................................................................................................................................11
5.数据库实施 .................................................................................................................................................11
5.1 建立数据库，数据表，视图，索引 .............................................................................................11
5.1.1 建立数据库 ...........................................................................................................................11
5.1.2 建立数据表 ...........................................................................................................................11
5.1.3 建立视图、索引 ...................................................................................................................13
5.1.4 建立存储过程 .......................................................................................................................14
5.2 数据入库 .........................................................................................................................................16
5.3 创建功能存储 .................................................................................................................................16
6.系统调试和测试 .........................................................................................................................................16
7.实习心得体会 .............................................................................................................................................24
8.存在问题与建议 .........................................................................................................................................24
参考文献 ........................................................................................................................................................24
附录 ................................................................................................................................................................25
附录 1.业务流程及数据流程图 ...........................................................................................................25
附录 2. ER 模型设计 ............................................................................................................................31
VIP享7折，此内容立减5.97元 
