1.18 ER Diagram

Discuss the importance of data modeling 讨论数据建模的重要性

Write good names and definitions for entities, relationships, and attributes 为实体、关系和属性编写良好的名称和定义

Distinguish unary, binary, and ternary relationships 区分一元、二元和三元关系

Model different types of attributes, entities, relationships, and cardinalities 对不同类型的属性、实体、关系和基数进行建模

Draw E-R diagrams for common business situations 绘制常见业务情况的 E-R 图

Convert many-to-many relationships to associative entities 将多对多关系转换为关联实体

Model time-dependent data using time stamps 使用时间戳对时间相关数据进行建模

Use of supertype/subtype relationships 使用超类型/子类型关系

Use of generalization and specialization techniques 使用泛化和专业化技术

Specification of completeness and disjointness constraints 完整性和不相交约束的规范

Develop supertype/subtype hierarchies for realistic business situations 为实际业务情况开发超类型/子类型层次结构

Develop entity clusters 发展实体集群

Name categories of business rules 业务规则的名称类别

Define operational constraints graphically and in English 以图形方式和英语定义操作约束

Definition of business rules, good data names, good data definition

• Business Rules: Statements that define or constrain some aspect of the business; Are derived from policies, procedures, events, functions; Assert business structure; Control/influence business behavior; Expressed in terms familiar to end users; Automated through DBMS software
  • Classification: Structural assertion—rule expressing static structure. Includes attributes, relationships, and definitions; Derivation—rule derived from other knowledge, often in the form of a formula using attribute values; Action assertion—rule expressing constraints/control of organizational actions. 结构断言——表达静态结构的规则。包括属性、关系和定义；推导——从其他知识导出的规则，通常采用使用属性值的公式的形式；行动断言——表达组织行动的约束/控制的规则。
  • Good: Declarative—what, not how, Precise—clear, agreed-upon meaning, Atomic—one statement,