Entity-Relationship Modeling

Foundations of Database Technology

Bernhard Thalheim
Springer, Heidelberg, February 2000, ISBN 3-540-65470-4

Table of contents:

  1. Introduction
    1
    1. Database Design
      1
    2. Overview of the Book
      5
    3. Advantages of the Approach
      7
  2. The Database Design Process
    13
    1. Databases and Design
      13
    2. Design Quality
      18
    3. Objects to be Modelled
      26
  3. The Entity-Relationship Model
    29
    1. The Structural Model
      29
    2. Problems
      39
  4. Extending the Entity-Relationship Model
    55
    1. Overview of Extensions
      56
    2. Entity and Relationship Types
      60
    3. Representing Structures of Applications through HERM-Diagrams
      73
    4. Benefits of the HERM Approach
      83
    5. Extending the Model To Become More Meaningful
      94
  5. Integrity Constraints
    105
    1. Logical Foundations of Semantics
      111
    2. Generalizing Relational Constraints
      123
    3. Entity-Relationship Constraints
      164
    4. Graphical Constraints
      200
    5. Incompleteness during Semantics Acquisition
      208
    6. Constraints in Models with Richer Type Systems
      214
  6. Operations
    219
    1. ER Languages
      219
    2. The HERM Algebra
      223
    3. Query-By-Example
      245
    4. The Logical Calculus
      250
    5. Query Forms
      253
    6. Behavior Models
      256
  7. Behavior Modeling
    263
    1. Dynamic and Temporal Integrity Constraints
      263
    2. Dynamic Semantics
      271
    3. Axiomatic Approach to Behavior Modeling
      288
    4. Enforcing Integrity Constraints
      294
    5. Soft Constraints and Deontic Logics
      309
  8. Applying the Theory
    313
    1. Identification in ER Schemata
      313
    2. Classifying Binary, Is-A- and Subobject-Relationship Types
      323
    3. Views
      332
    4. Equivalence in HERM Schemes
      368
    5. Normalization
      388
  9. The Database Design Process in HERM
    417
    1. Database Design Methodologies
      419
    2. Classical Database Design Methodologies
      426
    3. The HERM Methodology based on Modular Design
      438
    4. Codesign of Structures, Functions and Interaction
      456
    5. Natural Language Based Database Design
      469
    6. Computer-Aided Database Design
      478
  10. The Translation of HERM Schemes
    495
    1. The Relational Representation
      495
    2. The Network and Hierarchical Representation
      524
    3. Reverse Engineering of Translated Schemes
      535
  11. Open Problems
    541

Other features:




Return to the HERM book homepage, to the home page of B. Thalheim, to the research page, to the pages on teaching or on projects.