Case method : entity relationship modelling / Richard Barker.

CONTENIDO
Foreword v
Preface vii
Chapter 1. Introduction 1-1
Objectives of Entity Relationship Modelling 1-1
Generic Models 1-1
Why is Entity Relationship Modelling Important? 1-2
Your Challenge 1-3
Ten Key Issues 1-4
Chapter 2. A Simple Example 2-1
The Example - Tickets for Airlines 2-1
Database Implementation 2-9
So What Have We Found? 2-13
Chapter 3. Basic Conventions and Definitions 3-1
Entity 3-1
Entity Rules 3-2
Business Relationship 3-3
Attribute 3-8
Attribute Rules 3-9
Unique Identifier 3-13
Type and Instance 3-14
Layout Rules 3-16
Chapter 4. A Second Example 4-1
The Example 4-1
Credit Card Solution 4-6
Conclusion 4-8
Chapter 5. Identifying Entities, Attributes and Relationships 5-1
Identifying Entities 5-1
Identifying Attributes 5-6
Identifying Relationships 5-8
Summary 5-12
Chapter 6. A Complex Example 6-1
Atlantis Island Flights 6-1
Model the Open Ticket 6-3
Function Example 6-8
User Presentation 6-10
So What Have We Found? 6-11
Chapter 7. Advanced Conventions and Definitions 7-1
Entity 7-2
Relationships 7-7
Domain 7-16
Attribute 7-17
Summary 7-20
Chapter 8. Classical Structures and Generic Patterns 8-1
Hierarchies 8-2
Networks 8-7
Changes Over Time 8-9
Bill of Materials 8-10
Classifications and Categories 8-12
Entity Types 8-14
Specific Examples 8-15
Generic Patterns 8-25
A Word of Warning 8-27
Chapter 9. Related Concepts 9-1
Dataflow and Datastore 9-1
Business Function/Process 9-3
Business Event 9-3
Schema Architecture 9-3
External Schema 9-3
Entity Life-cycle 9-4
Chapter 10. Quality and Completeness Checks 10-1
Peer Group Check 10-1
User Approval 10-1
Rules 10-1
Quality of Entities 10-2
Quality of Attributes 10-3
Quality of Relationships 10-3
Completeness Check 10-4
Summary 10-4
Chapter 11. Presentation to Senior Management 11-1
Management Direction 11-1
Summary Diagrams 11-1
Summary 11-4
Appendix A. Data Normalization A-1
The Purpose A-1
Entity Modelling A-1
Normalization A-2
Intuitive Normalization A-4
Terminology A-6
Mathematical Definitions A-6
Beyond 3NF with Entity Relationship Modelling A-7
Data Denormalization A-7
Appendix B. Valid Relationships B-1
Many to One B-1
One to One B-2
Many to Many B-3
Recursive Relationships B-4
Appendix C. Detailed Definitions of Entity, Relationship, Domain and Attribute C-1
Entity Definition C-5
Relationship Definition C-8
Domain Definition C-13
Attribute Definition C-16
Appendix D Use of CASE Tools D-1
Case Support for the Business System Life Cycle D-2
Strategy Stage D-3
Analysis Stage D-3
Summary D-4
Appendix E. Data Administration E-1
Data Administration - The Role E-l
Control E-1
A Key Role E-2
Appendix F. Relational Database Design F-1
Simple Database Design F-l
Alternative Entity Models and their Impact on Design F-11
Derived Attributes F-13
Next Steps F-13
Appendix G Business View G-1
Business View G-l
Business Functions G-7
Data Dependence G-8
Summary G-9
Appendix H Meta Model H-1
What is a Meta Model? H-l
Appendix I. Atlantis Island Flights- Full Model I-1
Appendix J. Other Modelling Conventions J-1
Glossary Gl-1
Index In-1