目 录
1. 系统需求分析阶段 ...............................................................................................................1
1.1 引言 ............................................................................................................................1
1.2 目标与任务 .................................................................................................................1
1.2.1 需求分析阶段的目标.......................................................................................1
1.2.2 需求分析阶段的任务.......................................................................................1
1.2.3 需求分析阶段成果 ..........................................................................................2
2. 概念设计阶段 ....................................................................................................................11
2.1 引言 ..........................................................................................................................11
2.2 概念模型设计 ...........................................................................................................12
2.3 新系统流程 ...............................................................................................................13
3．逻辑设计阶段 ....................................................................................................................14
3.1 逻辑设计的任务和目标 .............................................................................................14
3.2 数据组织....................................................................................................................14
3.2.1 将 E-R 图转换为关系模型 ..............................................................................14
3.2.2 模型优化 ........................................................................................................15
3.2.3 数据库模式定义 .............................................................................................16
3.2.4 用户子模式设计 .............................................................................................16
3.3 数据处理....................................................................................................................16
4．物理设计阶段 ....................................................................................................................17
4.1 物理设计阶段的目标与任务 ......................................................................................17
4.2 数据存储方面 ............................................................................................................17
4.3 系统功能模块 ............................................................................................................17
4.3.1 楼道工人基本的信息查询和更新模块 ...........................................................18
4.3.2 宿舍楼基本信息的查询和更新模块 ..............................................................18
4.3.3 宿舍基本信息的查询和更新模块 ..................................................................19
4.3.4 学生基本信息的查询和更新模块 ..................................................................20
4.3.5 宿舍物品的查询和更新模块..........................................................................20
4.3.6 宿舍事故的查询和更新模块..........................................................................21
4.3.7 宿舍物品处理的查询和更新模块 ..................................................................21
4.3.8 宿舍保卫处基本信息的查询和更新模块 .......................................................22
5．数据库实施阶段 .................................................................................................................22
5.1 建立数据库、数据表、视图、索引 ...........................................................................22
5.1.1 建立数据库 ....................................................................................................22
5.1.2 建立数据表 ....................................................................................................22
5.1.3 建立视图 .......................................................................................................26
5.1.4 建立索引 .......................................................................................................28
