数据库系统概论第七章

1、An Introduction to Database System数据库系统概论数据库系统概论An Introduction to Database System第七章第七章 数据库设计数据库设计An Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database System现实世界现实世界概念模型设计概念模型设计子模式设计子模式设计物

2、理数据库设计物理数据库设计逻辑数据库设计逻辑数据库设计建立数据库建立数据库数据分析数据分析功能分析功能分析功能模型功能模型功能说明功能说明事务设计事务设计程序说明程序说明应用程序设计应用程序设计程序编码调试程序编码调试结构和行为分离的设计 An Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introdu

3、ction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn I

4、ntroduction to Database System数据库设计各个阶段的设计描述An Introduction to Database SystemAn Introduction to Database System数据库的各级模式 An Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introd

5、uction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database System数据流数据流数据流数据流数据数据存储存储信息要求信息要求数据数据来源来源处理处理数据数据输出输出处理要求处理要求An Introduction

6、 to Database SystemAn Introduction to Database System需求分析过程 An Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn

7、 Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database Sy

8、stemAn Introduction to Database SystemAn Introduction to Database System现实世界现实世界机器世界机器世界信息世界信息世界需求分析需求分析概念结构设计概念结构设计An Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database System自顶向下策略An Introduction to Database System自底向上策略An

9、 Introduction to Database System逐步扩张策略An Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database Systemv自底向上设计概念结构的步骤 第1步：抽象数据并设计局部视图第2步：集成局部视图，得到全局概念结构An Introduction to Database SystemAn Introduction to Database SystemAn Introd

10、uction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database System 聚集 An Introduction to Database System 复杂的聚集，某一类型的成分仍是一个聚集 更复杂的聚集 An Introduction to Database SystemAn Introduction to Database System概括 An

11、 Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database System设计分E-R图的出发点 An Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database System职称作为一个实体An Introduction to Database System病房作为一个实体An Introduction to Database System仓库

12、作为一个实体An Introduction to Database SystemAn Introduction to Database System图7.18 销售管理子系统第一层数据流图 An Introduction to Database System图7.19 接收订单 An Introduction to Database System图7.20 处理订单 An Introduction to Database System图7.21 开发票 An Introduction to Database System图7.22 支付过账 An Introduction to Databas

13、e System分E-R图的框架 An Introduction to Database SystemAn Introduction to Database System销售管理子系统的分E-R图 An Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database Sys

14、temAn Introduction to Database System视图集成 An Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database System合并合并初步初步E-R图图分分E-R图图可能存在冗余的数据可能存在冗余的数据和冗余的实体间联系和冗余的实体间

15、联系基本基本E-R图图消除不必要的冗余消除不必要的冗余An Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database System消除冗余 An Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database System劳动人事管理的分E-R图 An Introduction t

16、o Database SystemAn Introduction to Database SystemAn Introduction to Database System支持的数据模型，它是各种数据模型的共同基础，因而比数据模型更一般、更抽象、更接近现实世界。An Introduction to Database System支持的数据模型，它是各种数据模型的共同基础，因而比数据模型更一般、更抽象、更接近现实世界。图1.14(c) 工厂物资管理E-R图该厂物资管理分E-R图An Introduction to Database System支持的数据模型，它是各种数据模型的共同基础，因而比数据

17、模型更一般、更抽象、更接近现实世界。图7.24 销售管理子系统的分E-R图该厂销售管理分E-R图An Introduction to Database System支持的数据模型，它是各种数据模型的共同基础，因而比数据模型更一般、更抽象、更接近现实世界。图7.29 劳动人事管理的分E-R图该厂劳动人事管理分E-R图An Introduction to Database System支持的数据模型，它是各种数据模型的共同基础，因而比数据模型更一般、更抽象、更接近现实世界。系统的基本E-R(图7.30)某工厂管理信息系统的基本E-R图 An Introduction to Database Sys

18、temAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Databa

19、se System逻辑结构设计时的3个步骤 An Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Int

20、roduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database System

21、An Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database

22、SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database System数据库物理设计数据库物理设计确定数确定数据库

23、的据库的物理结物理结构构评价数据评价数据库的物理库的物理结构结构逻辑结逻辑结构设计构设计数据库数据库实施实施物理物理模型模型逻辑逻辑模型模型An Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Databas

24、e SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to D

25、atabase SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction to Database SystemAn Introduction t