目录
1. 系统概况 .........................................................................................................................................................................1
2.系统分析 ...........................................................................................................................................................................1
2.1 需求分析 ....................................................................................................................................................................1
2.2 需求分析途径 ............................................................................................................................................................1
a
、
用户需求的收集
..................................................................................................................................................1
b
、
用户需求的分析
..................................................................................................................................................1
c
、
网上调查
..............................................................................................................................................................1
d
、
相关企业调查
......................................................................................................................................................1
3.系统体系结构 ...................................................................................................................................................................2
3.1 设计目标 ....................................................................................................................................................................2
3.2 体系功能结构 ...........................................................................................................................................................2
4.数据库设计 .......................................................................................................................................................................2
4.1
数据模型
................................................................................................................................................................2
4.2
详细设计
...............................................................................................................................................................4
4.2.1
数据库
................................................................................................................................................................4
(
1
)
数据库定义
......................................................................................................................................................4
4.2.2 manager
(管理表)
...........................................................................................................................................5
(
2
)
表结构
..............................................................................................................................................................5
4.2manager
(管理员信息表)表结构
.......................................................................................................................5
(
2
)
定义
T-SQL
语句
.............................................................................................................................................5
(
3
)数据管理
............................................................................................................................................................5
主要的任务有查询、添加、修改、删除学生信息,主要的
SQL
如下:
.............................................................5
4.2.3 book
(图书信息表)
.........................................................................................................................................5
(
1
)表结构
................................................................................................................................................................5
4.3 book
(图书信息表)表结构
................................................................................................................................5
(
2
)
定义
T-SQL
语句
.............................................................................................................................................6
(
3
)数据管理
............................................................................................................................................................6
主要的任务有查询、添加、修改、删除图书信息,主要的
SQL
如下:
.............................................................6
4.2.4 customers
(客户表)
.........................................................................................................................................7
(
1
)表结构
................................................................................................................................................................7
4.4 customers
(客户信息表)表结构
........................................................................................................................7
(
2
)定义
T-SQL
语句
...............................................................................................................................................7
(
3
)数据管理
............................................................................................................................................................7
主要的任务有查询、添加、修改、删除图书信息,主要的
SQL
如下:
.............................................................7
4.2.5 bookstore
(书店表)
.........................................................................................................................................7
(
1
)表结构
................................................................................................................................................................7
4.5 bookstore
(书店信息表)表结构
........................................................................................................................7
(
2
)定义
T-SQL
语句
...............................................................................................................................................8
(
3
)数据管理
............................................................................................................................................................8
主要的任务有查询、添加、修改、删除图书信息,主要的
SQL
如下:
.............................................................8
4.2.6 orders
(订单表)
..............................................................................................................................................8
(
1
)表结构
................................................................................................................................................................8