!" #$%&$'()"#**+,%-!.!/%
0%12134*# 56!7!8!(3!%!99":!%!!6;!!!*%!--
%<5;.":5;!<+%*=3>?9!!%!!2"!@0/"A6AB0!*C!=5> "!!&%4
4!!'!-!*4
目 录
1. 设计背景........................................................................................................................................................1
1.1 了解 SQL Server 2000.........................................................................................................................1
1.2 数据库的开发目的.............................................................................................................................1
2.设计方案.........................................................................................................................................................2
2.1 课题描述及分析..................................................................................................................................2
2.2 ER 模型................................................................................................................................................2
2.3 关系模式..............................................................................................................................................3
3. 方案实施........................................................................................................................................................3
3.1 创建数据库..........................................................................................................................................3
3.2 创建表..................................................................................................................................................4
3.3 编辑数据..............................................................................................................................................6
3.3.1 插入...........................................................................................................................................6
3.3.2 删除...........................................................................................................................................7
3.3.3 修改...........................................................................................................................................7
3.4 检索数据..............................................................................................................................................8
3.5 创建索引和视图..................................................................................................................................9
4.结论...............................................................................................................................................................12
4.1 收获....................................................................................................................................................12
5. 参考文献......................................................................................................................................................12
!9 !!4%!!!&<! G!$!&*$4!&-4!%@<!.<!<!!J&!4
!0