内容

目次

Foreword Preface 1. Introduction Objectives of Entity Modelling *Generic Models * Why is Entity Relationship Modelling Important? * YourChallenge * Ten Key Issues 2. A Simple Example The Example-Tickets forAirlines * Database Implementation * So What Have We Found? 3. BasicConventions and Definitions Entity * Entity Rules * Business Relationship *Attribute * Attribute Rules * Unique Identifier * Type and Instance * LayoutRules 4. A Second Example The Example * Credit Card Solution * Conclusion5. Identifying Entities, Attributes and Relationships Identifying Entities *Identifying Attributes * Identifying Relationships * Summary 6. A ComplexExample Atlantis Island Flights *Model the Open Ticket * Function Example *User Presentation * So What Have We Found? 7. Advanced Conventions andDefinitions Entity * Relationships * Domain * Attribute * Summary 8.Classical Structures and Generic Patterns Hierarchies * Networks * ChangesOver Time * Bill of Materials * Classification and Categories * Entity Types* Specific Examples * Generic Patterns * A Word of Warning 9. RelatedConcepts Dataflow and Datastore * Business Function/Process * Business Event* Schema Architecture * External Schema * Entity Life-cycle 10. Quality andCompleteness Checks Peer Group Check * User Approval * Rules * Quality ofEntities * Quality of Attributes * Quality of Relationships * CompletenessCheck * Summary 11. Presentation to Senior Management Management Direction* Summary Diagrams * Summary Appendices Appendix A. Data Normalization ThePurpose * Entity Modelling * Normalization * Intuitive Normalization *Terminology * Mathematical Definitions * Beyond 3NF with Entity RelationshipModelling * Data Denormalization Appendix B. Valid Relationships Many toOne * One to One * Many to Many * Recursive Relationships Appendix C.Detailed Definitions of Entity, Relationship, Domain and Attribute EntityDefinition * Relationship Definition * Domain Definition * AttributeDefinition Appendix D. Use of CASE Tools Case Support For the BusinessSystem Life Cycle * Strategy Stage * Analysis Stage * Summary Appendix E.Data Administration Data Administration-The Role * Control * A Key RoleAppendix F. Relational Database Design Simple Database Design * AlternativeEntity Models and their Impact on Design * Derived Attributes * Next StepsAppendix G. Business View Business View * Business Functions * DataDependence * Summary Appendix H. Meta Model What is a Meta Model? AppendixI. Atlantis Island Flights-Full Model Glossary Index