Case Method
Entity Relationship Modelling
Published on 1. January 1990
Book
Paperback/Softback
240 pages
978-0-201-41696-1 (ISBN)
Description
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.
.
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.
.
Reviews / Votes
"It was a pleasure to write the Foreword for such a well-written, informative book ( Case Method: Entity Relationship Modelling ), I learned some new guidelines for entity relationship modelling when I read it over."- Dr Carma McClure, Vice President of Research, Extended Intelligence Inc.
"Richard Barker has managed to encapsulate in book form ( Case Method: Entity Relationship Modelling ) his many years of data modelling theory and practice. His new book comfortably achieves the seemingly impossible task of being both introductory and definitive at one and the same time."
- Russell Jones, Editor, Software Development Monitor
More details
Language
English
Place of publication
Harlow
United Kingdom
Publishing group
Pearson Education Limited
Target group
Professional and scholarly
Dimensions
Height: 242 mm
Width: 190 mm
Thickness: 20 mm
Weight
820 gr
ISBN-13
978-0-201-41696-1 (9780201416961)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Content
Foreword
Preface
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
Appendices
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
Attribute
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
Glossary
Index
Preface
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
Appendices
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
Attribute
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
Glossary
Index