Linked e-resources
Details
Table of Contents
At a Glance; Contents; About the Author; Preface; Part I: Introduction; Chapter 1: Introduction to Usage-Driven Database Design; Database Design Principle 1: Separation Principle; Database Design Principle 2: Distinction Principle; The Difference Between Separation and Distinction; Database Design Principle 3: Convergence Principle; The Separation, Distinction, and Convergence Principles; Database Design Principle 4: Minimal Regression Principle; Usage-Driven Database Design; Logical Data Modeling; Physical Schema Definition; The Terminology Trap; Notes
Part II: Logical Data ModelingChapter 2: The E-R Approach; A Little Data Modeling History; Some Important Definitions; Logical Data Modeling Objects; Entities; Type-Instance Distinction; Relationships; Attributes; Notes; Chapter 3: More About the E-R Approach; More About Relationships; Membership Class; Cardinality; Modality; Degree; Binary Relationship; N-ary Relationships; Unary or Recursive Relationships; Relationship Constraints; Inclusion; Exclusion; Conjunction; Simple Conjunction; Conditional Conjunction; Recursive Modality Constraints; More About Entities; Attributive Entity
Associative EntitiesSupertype and Subtype Entities (Generalization and Specialization); More About Attributes; Attribute Domain; Attribute Source: Primitive and Derived; Attribute Descriptor and Unique Identifier; Compound or Concatenated Unique Identifiers; Attribute Complexity: Simple and Group; Attribute Valuation: Single Value and Multivalue; Attribute Complexity and Valuation; Chapter 4: Building the Logical Data Model; The Interview Process; Gather Information and Review; 1. Identify the Users Who Are Authorities or Experts on the Subject
2. Meet and Interview the Experts and Identify the Subject (Application) EntitiesPreparation; The First Interview; 3. Identify Relationships Between the Entities; 4. Identify the Properties or Attributes of the Entities and Relationships; Analyze Information; Construct Model; Repeat as Necessary; Making Sense of the Interview; Modeling Rules; Verifying What You Have Heard; Immediate Interview Feedback; Formal Walk-Throughs; Increasing E-R Diagram Comprehension; Subject Areas; Entity Fragments; Neighborhood Diagrams; Relationship Bridges and Stubs; Some Model Building Best Practices
Getting StartedDon't Lose Control of the Project to Users; Don't Lose Control of the Project to Technical Staff; Don't Become Dependent on Tools or Techniques; Don't Get Bogged Down in Endless Analysis; The Players…and the Rules of Engagement; Deliverables; Examples of Deliverables; Sample Data Dictionary, Data Object Definitions; Notes; Chapter 5: LDM Best Practices; Abbreviations; Almost Unique Identifiers; Clarity; Compound Unique Identifiers; Conceptual Integrity; Conjunctive Relationships; Duplicate Super-Subtypes "Type" Data; Exclusive and Nonexclusive Generalization
Part II: Logical Data ModelingChapter 2: The E-R Approach; A Little Data Modeling History; Some Important Definitions; Logical Data Modeling Objects; Entities; Type-Instance Distinction; Relationships; Attributes; Notes; Chapter 3: More About the E-R Approach; More About Relationships; Membership Class; Cardinality; Modality; Degree; Binary Relationship; N-ary Relationships; Unary or Recursive Relationships; Relationship Constraints; Inclusion; Exclusion; Conjunction; Simple Conjunction; Conditional Conjunction; Recursive Modality Constraints; More About Entities; Attributive Entity
Associative EntitiesSupertype and Subtype Entities (Generalization and Specialization); More About Attributes; Attribute Domain; Attribute Source: Primitive and Derived; Attribute Descriptor and Unique Identifier; Compound or Concatenated Unique Identifiers; Attribute Complexity: Simple and Group; Attribute Valuation: Single Value and Multivalue; Attribute Complexity and Valuation; Chapter 4: Building the Logical Data Model; The Interview Process; Gather Information and Review; 1. Identify the Users Who Are Authorities or Experts on the Subject
2. Meet and Interview the Experts and Identify the Subject (Application) EntitiesPreparation; The First Interview; 3. Identify Relationships Between the Entities; 4. Identify the Properties or Attributes of the Entities and Relationships; Analyze Information; Construct Model; Repeat as Necessary; Making Sense of the Interview; Modeling Rules; Verifying What You Have Heard; Immediate Interview Feedback; Formal Walk-Throughs; Increasing E-R Diagram Comprehension; Subject Areas; Entity Fragments; Neighborhood Diagrams; Relationship Bridges and Stubs; Some Model Building Best Practices
Getting StartedDon't Lose Control of the Project to Users; Don't Lose Control of the Project to Technical Staff; Don't Become Dependent on Tools or Techniques; Don't Get Bogged Down in Endless Analysis; The Players…and the Rules of Engagement; Deliverables; Examples of Deliverables; Sample Data Dictionary, Data Object Definitions; Notes; Chapter 5: LDM Best Practices; Abbreviations; Almost Unique Identifiers; Clarity; Compound Unique Identifiers; Conceptual Integrity; Conjunctive Relationships; Duplicate Super-Subtypes "Type" Data; Exclusive and Nonexclusive Generalization