CHAPTER 5: What are relationships?              53

Relationship Explained              53

Relationship Types              53

Cardinality Explained              54

Recursion Explained              58

Relationship Descriptions              60

Subtyping Explained              60

EXERCISE 5: Reading a Model              61

CHAPTER 6: Why are names and definitions important?              63

Clarity              65

Completeness              65

Accuracy              66

Lack of Ambiguity              67

Not Only Entities and Data Elements              67

Especially Relationships              67

The Need for Naming Standards              68

CHAPTER 7: What are keys?              71

Key Explained              71

Candidate Key Explained              71

Primary and Alternate Keys Explained              74

Surrogate Key Explained              75

Foreign Key Explained              76

EXERCISE 6: Clarifying Customer Id              78

SECTION III: Data Modeling in PowerDesigner              79

CHAPTER 8: Why do we need a data modeling tool?              81

Why not use a drawing tool for data modeling?              81

Key Features Needed in a Data Modeling Tool              82

EXERCISE 7: Examining Your Current Data Modeling Tool              85

CHAPTER 9: What can PowerDesigner do for me?              87

What is metadata?              87

PowerDesigner metadata scope              88

PowerDesigner Data Models              88

Data Modeling Feature Comparison              89

Core Modeling              89

Usability              97

Interfaces And Integration              98

Tool Management And Communication              100

Collaboration              100