1 / 104

IDEF 1X Concept AND ERw in Operation

IDEF 1X Concept AND ERw in Operation. Own. Design. Build. MODEL 一种运用图形化呈現设计元件 ，並更加清楚 的呈現原本的功能. Examples:. ． a sketch………….………………. ． a miniature representation. ． a blueprint.............………. 参与 / 授课給. 课程. 学生. Course ID. Student ID. Student Last Name Student First Name

haruki
Download Presentation

IDEF 1X Concept AND ERw in Operation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IDEF 1X ConceptAND ERwin Operation

  2. Own Design Build MODEL 一种运用图形化呈現设计元件 ，並更加清楚 的呈現原本的功能 Examples: ．a sketch………….……………… ．a miniature representation. ．a blueprint.............………..

  3. 参与/ 授课給 课程 学生 Course ID Student ID Student Last Name Student First Name Student Dormitory Student Major Course Title Course Number of Credits Course Location Course Instructor Name Data Model 一种运用一般业务知识來表現业务需求的一种数据 结构规则

  4. Data Modeling 一个结构化的方法，去定义一个信息系統元件的規 格說明

  5. 信息模型的功用: 提供企业整体信息共享 以图形提供专业化业务规则与需求 作为技术人員与企业人員的桥梁 建立一致性 建立一种静态数据模型 为何需要信息模型?

  6. I DEF 1 X e IDEF1X • 建立数据模型方法－是一种语言 • 起源于美國空軍(1970s) • 美國政府单位与工业界已使用超过10年(FIPS PUB 184,1993) FIPS PUB:FEDERAL INFORMATION PROCESSING STANDARDS PUBLICATION

  7. IDEF1X • IDEF0－通过分解功能、分类功能间的联系来描述系统功能 • IDEF1－用于描述企业重要管理资料的方法 • IDEF1X－关系数据库的设计方法 • IDEF2－一种以数字逻辑为基础的模拟方法 • IDEF3－为自使用者描述系统结构的方法 • IDEF4－一种面向对象式数据库的设计方法 • IDEF5－是一种收集事实与资料的方法 • IDEF6－是信息系统设计原理的描述方法

  8. ORDER Order Number Sales Representative Id (FK) Shipment Method Code (FK) Payment Number (FK) Customer Number (FK) Order Date Order Shipment Charge Order Total Order Shipment Date (IE4) 包含 LINE ITEM Order Number (FK) Line Item Sequence Number Product Code (FK) Line Item Quantity Line Item Total IDEF 1X逻辑模型 ( Logical Model ) • 一种用來提供业务行为的规范或準則的信息模型 结构化呈現 DBMS 独立性 一种表示业务信息及业务行为规范的语言 结构性呈現 独立于DBMS

  9. SALES ORDER Transaction Patterns Hardware Considerations Sales_Order_Number: int NOT NULLSales_Order_Date: datetimeSales_Order_Status: char(1) Sales_Order_Notes: varchar(100) DBMSFunctions PhysicalModel Sales Order IDEF 1X物理数据模型(Physical Data Model) 一种描述数据结构设计及实施的規格依賴于 DBMS利用SQL下的DDL方法來设计与实施 设 计 建 置 SQL Script/DDL CREATE TABLE SALES_ORDER ( Sales_Order_Numberint NOT NULL, Sales_Order_Date datetime NULL, Sales_Order_Status char(1) NULL, Sales_Order_Notes varchar(100) NULL ) go CREATE UNIQUE INDEX XPKSALES_ORDER ON SALES_ORDER ( Sales_Order_Number ) go

  10. ServerEnvironment Client Environment E Rwin Visual Basic PowerBuilder DB2 ORACLE SQL Anywhere SQL Server Informix Access Paradox FoxPro Sybase ERwin在Client/Server 发展环境的角色

  11. Create IDEF 1X Data Model

  12. 主要內容： • －了解，建立，编辑： • Entities • Attributes • Keys • Relationships • Stored Displays and Subject Area

  13. ENTITY 人, 地点, 物, 事件以及任何包含业务活动数据的概念 . 每个ENTITY是由一组相似的对象 组成，這些对象称为INSTANCES 每一个INSTANCE必須能单独标识 且須和其它INSTANCE有所别

  14. EMPLOYEE 人 STUDENT OFFICE 地方 COUNTRY AUTOMOBILE 物 CHEMICAL FUNDS TRANSFER 事件 TENNIS TOURNAMENT DEPARTMENT 概念 ORDER ENTITY Examples 分类 ENTITY Instance Mr.Koch Ms.Chou Taipei R.O.C BMW 525i Ammonia 42233 U.S. OPEN L789 I12345

  15. IDEF1X Entity Types 两种类別 独立实体 ORDER 其存在不需要其他 ENTITY 来标识 非独立实体 LINE ITEM 其存在必为其他一或多 ENTITY 所标识

  16. ATTRIBUTE 用來分辨或說明实体的性质与特征 ,亦是数据真正处理的值 EMPLOYEE Employee Id Employee Last Name Employee First Name Employee Address Employee Phone Number ENTITY Name attributes

  17. 两种属性类別 键属性(Key) 非键属性(Non Key) CONSULTANT 键属性 Consultant Id Consultant Last Name Consultant First Name Consultant Specialization Consultant Hourly Rate 非键属性 属性类別

  18. Candidate Keys 任何一个属性或一组属性其可用來唯一认定实体中的每个INSTANCE TEACHER Teacher Last Name Teacher First Name Teacher Address Teacher Country Teacher Certificate Id Teacher Mother Maiden Name Teacher Phone Number Teacher Date of Birth TEACHER Teacher Last Name Teacher First Name Teacher Address Teacher Country Teacher Certificate Id Teacher Mother Maiden Name Teacher Phone Number Teacher Date of Birth

  19. Primary Key,PK 实体中所有候选键中被指定为最优先或最常用來唯一标识每个实例的某个属性或一组属性 老師 PK 教 職 員 编 号 姓 名字 住址國別電話 生日

  20. 除PK外的所有候选键 以 (AKn)表示 假如換用键本身包含好几个属性 , 每个属性后面均需加(AKn) Alternate Key EMPLOYEE Employee Id Employee Last Name (AK1) Employee First Name (AK1) Employee Address Employee City Employee State Employee Zip Code Employee Phone Number (AK2) Employee Date of Birth (AK1,AK2)

  21. Inversion Entries EMPLOYEE • 利用其余属性來查找 其所需的实体实例但 其結果並不具唯一性 • 以 (IEn)表示 • 假如換用键本身包含 好几个属性 , 每个属 性后面均需加(IEn) Employee Id Employee Last Name (AK1,IE2) Employee First Name (AK1) Employee Address Employee City (IE1) Employee State (IE1) Employee Zip Code Employee Phone Number Employee Date of Birth (AK1)

  22. Relationship 两实体间关联性的表示 学生 修课 课程 学生修课

  23. 子 代 父 代 父 代 子 代 P 父 代 子 代 Z 子 代 父 代 N Relationship的基数性 每一父代能拥有零或一或多个子代 每一父代能拥有一或多个子代 每一父代能拥有零或一个子代 每一父代能拥有N个子代

  24. FOREIGN KEY(FK) 父ENTITY的PK通过RELATIONSHIP加入到子ENTITY中作为PK，此称之为FOREIGN KEY LINE ITEM 訂单编号(FK)Line Item Sequence Number Item QuantityItem NumberItem Description 訂单 訂单编号 Order Date Order Sales Representative Order Customer contains

  25. MOVIE COPY MOVIE MASTER Movie Master Id (FK)Movie Copy Number Movie Copy Create Date Movie Copy Due Date Movie Copy Condition Movie Master Id is rented as/ is created from Movie Name Movie Star Movie Type Movie Rating Identifying Relationship 实体主键迁移給子实体作为部分主键(PK) 实体須由父实体决定,其存在亦需依附父实体

  26. ORDER CUSTOMER Order Number Customer Id places/ is received from Customer Id (FK) Order Date Order Status Order Shipdate CustomerName CustomerAddress CustomerPhone Non-IdentifyingMandatory Relationship 实体主键迁移給子实体作为非键属性(非PK) , 其表示並不能由父实体來决定子实体为何 子实体不須由父实体决定,但其存在仍需依附父实体 (mandatory)

  27. Department Number DepartmentName DepartmentLocation Non-IdentifyingNon-Mandatory Relationship ．实体 PK 迁移到子实体当作非主键且与子实体为非标识行 ( Non-Identifying )．实体与父实体间的标识为独立存在性．实体信息本身不需完全依賴父实体 DEPARTMENT EMPLOYEE Employee Id employs/ belongs to Department Number (FK) Employee Name Employee Address

  28. ＊一种不确定关系－主键並不迁移給它实体做为外來键＊一种不确定关系－主键並不迁移給它实体做为外來键 ＊必須有两种动词(片语) ＊ 两种关系:－ 父对子关系－ 子对父关系 Many-to-Many Relationship is ordered from/sends us PART SUPPLIER

  29. 相关性 存在性 特定性 MOVIE COPY MOVIE MASTER Yes Yes Yes No No No - - Movie Master Id (FK) Movie Copy Id Movie Copy Due Date Movie Master Id Movie Master Name ORDER CUSTOMER Order Number Customer Id (FK) Order Shipment Date 继承 Customer Id Customer Name EMPLOYEE DEPARTMENT 非继承 Employee Id Department Id (FK) Employee Name Department Id Department Location (optionality indicator) PART SUPPLIER Part Number Part Description Supplier Id Supplier Name 关系类型总览

  30. Start 1 : 多 or 多 : 多? 决定父子关 系与基数 M:M关系建立 1:M M:M I特定 or 非特定? 非特定 继承 or 非继承? 特定 Draw and name anIdentifying Relationshipfrom Parent to Child 继承 Draw and name aNon-identifying Relationshipfrom Parent to Child FK - NULLS ALLOWED Draw and name aNon-identifying Relationshipfrom Parent to Child FK - NO NULL 关系性建立

  31. 此单元 ... ERwin使用工具 : Menus, Toolbar, & Toolbox Subject Areas Display Options ERwin 介紹

  32. ERwinIDEF1X Toolbox “mouse” 所选择的对象 分类设定 关系设定 Attribute 处理 增加背景文字 增加新实体

  33. ERwin IE Toolbox “mouse” 所选择的对象 分类设定 关系设定 Attribute 处理 增加背景文字 增加新实体

  34. 正向工程 MODEL MART工具列 顯示Entity的名字 範圍內放大 放大 新模型 选择目標数据庫 选择目標 顯示attribute和entity Complete Compare Entity定义 列印 Edit Subject Area 縮小 存檔 放大到和視窗一樣 開啟模型 正常顯示 ERwin Toolbar

  35. Á Â Ã À RelationshipHandle Toolbox 使用方法

  36. Toolbox

  37. Relationship 按右键

  38. Subject Area • Subject Area • 一个Data Model的子集合 • Subject Area其重点在整个Data Model中的某个计劃或企业內部的 某一範圍间entities的关联

  39. 建构Subject Area... 1) 按 or 由 Window 选項, 选择 ‘Subject Area...’ 3).Create New 2).Subject Area Name

  40. 你可以.. 选择所需的实体为何 預視实体定义 编辑Subject Area...

  41. ORDER ORDER An ORDER is a record of the purchase of a PRODUCT or PRODUCTS by a CUSTOMER. Order Number contains LINE ITEM LINE ITEM Order Number (FK)Line Item Sequence Number A component of an ORDER which specifies information relating to each PRODUCT being purchased. Display Levels... Primary Key Level Definition Level ORDER contains

  42. ORDER ORDER Order NumberOrder Date (IE1)Sales Representative Id (FK)Customer Number (FK)Shipment Method Code (FK)Order Shipment Date (IE4)Order Shipment ChargePayment Number (FK)Order Total contains contains LINE ITEM LINE ITEM Order Number (FK)Line Item Sequence NumberProduct Code (FK) Line Item QuantityLine Item Total Display Levels Physical Order Level ICON Level

  43. ORDER Order Number Order Date (IE1)Customer Number (FK)Sales Representative Id (FK) Shipment Method Code (FK) Order Shipment Date (IE4) Order Shipment ChargeOrder TotalPayment Number (FK) ORDER contains contains LINE ITEM LINE ITEM Order Number (FK)Line Item Sequence Number Product Code (FK) Line Item QuantityLine Item Total Display Levels... Entity Level Attribute Level

  44. 选择方式有: • Toolbar Icons • Display Menu • SMB on background Zoom Settings

  45. 正反向与同步比較 选择Target Server 正向工程 ( FE ) 反向工程 ( RE ) 同步比較 • 选择Target Server • 正向工程 ( FE ) • 反向工程 ( RE ) • 同步化工程

  46. 按 or 從 Server 选单 , 选择 ‘Target Server...’ 选择 Target Server... • 按 or • 從 Server 选单 , 选择 ‘Target Server...’

  47. Select Target Server select version 选择預设数据型态 组合 分析与修正设定的参考完整性( RI) 的預设值* Target Server...

  48. 重新设定物理数据庫名你 Click ‘Reset Physical Names...’ 有关 Target Server

  49. Reset Physical Names 使用选择功能 Click ‘OK’ 有关 Target Server 的选項

  50. 按 OR Tasks 选择 ‘Forward Engineer/Schema Generation’ 正向工程 • 按 • Tasks 选择 ‘Forward Engineer/Schema Generation’

More Related