Case Method: Entity Relationship Modelling, 1st edition

  • R Barker

Unfortunately, this item is not available in your country.


Now data analysts, strategists and data administrators can learn the powerful technique of entity relationship modelling from this definitive guide. In a lucid instructional style, Richard Barker shows how the data modelling technique can be applied to develop high-quality, integrated information systems. Special features of the book include:

  • a wealth of realistic examples illustrating the technique in practice
  • detailed appendices highlighting the key topics including data normalization, CASE tool support, data administration and database design
  • a definitive glossary of all important terms.


Table of contents



1. Introduction

Objectives of Entity Modelling * Generic Models * Why is Entity
Relationship Modelling Important? * Your Challenge * Ten Key Issues

2. A Simple Example

The Example-Tickets for Airlines * Database Implementation * So What
Have We Found?

3. Basic Conventions and Definitions

Entity * Entity Rules * Business Relationship * Attribute * Attribute
Rules * Unique Identifier * Type and Instance * Layout Rules

4. A Second Example

The Example * Credit Card Solution * Conclusion

5. Identifying Entities, Attributes and Relationships

Identifying Entities * Identifying Attributes * Identifying
Relationships * Summary

6. A Complex Example

Atlantis Island Flights *Model the Open Ticket * Function Example * User
Presentation * So What Have We Found?

7. Advanced Conventions and Definitions

Entity * Relationships * Domain * Attribute * Summary

8. Classical Structures and Generic Patterns

Hierarchies * Networks * Changes Over Time * Bill of Materials *
Classification and Categories * Entity Types * Specific Examples *
Generic Patterns * A Word of Warning

9. Related Concepts

Dataflow and Datastore * Business Function/Process * Business Event *
Schema Architecture * External Schema * Entity Life-cycle

10. Quality and Completeness Checks

Peer Group Check * User Approval * Rules * Quality of Entities * Quality
of Attributes * Quality of Relationships * Completeness Check * Summary

11. Presentation to Senior Management

Management Direction * Summary Diagrams * Summary


Appendix A. Data Normalization

The Purpose * Entity Modelling * Normalization * Intuitive Normalization
* Terminology * Mathematical Definitions * Beyond 3NF with Entity
Relationship Modelling * Data Denormalization

Appendix B. Valid Relationships

Many to One * One to One * Many to Many * Recursive Relationships

Appendix C. Detailed Definitions of Entity, Relationship, Domain and

Entity Definition * Relationship Definition * Domain Definition *
Attribute Definition

Appendix D. Use of CASE Tools

Case Support For the Business System Life Cycle * Strategy Stage *
Analysis Stage * Summary

Appendix E. Data Administration

Data Administration-The Role * Control * A Key Role

Appendix F. Relational Database Design

Simple Database Design * Alternative Entity Models and their Impact on
Design * Derived Attributes * Next Steps

Appendix G. Business View

Business View * Business Functions * Data Dependence * Summary

Appendix H. Meta Model

What is a Meta Model?

Appendix I. Atlantis Island Flights-Full Model



Published by Addison-Wesley Professional (January 1st 1990) - Copyright © 1990