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
    
    

• more than 150 sample ER diagrams
• references to relevant ER literature from page 549 to page 601 with more than 1.000 references
• index on 10 pages

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.