CA Technologies, 2011. — 98 p.
(Автор не указан).Contents:
Introduction.
Data Modeling Concepts.
Benefits of Data Modeling.
Methods.
Typographical Conventions.
Information Systems, Databases, and Models.
Introduction.
Data Modeling.
Data Modeling Sessions.
Session Roles.
Sample IDEF1X Modeling Methodology.
Modeling Architecture.
Logical Models.
Entity Relationship Diagram.
Key-Based Model.
Fully-Attributed Model.
Physical Models.
Transformation Model.
DBMS Model.
Logical Models.
How to Construct a Logical Model.
Entity Relationship Diagram.
Entities and Attributes Defined.
Logical Relationships.
Many-to-Many Relationships.
Logical Model Design Validation.
Data Model Example.
The Key-Based Data Model.
Key-Based Data Model.
Key Types.
Entity and Non-Key Areas.
Primary Key Selection.
Alternate Key Attributes.
Inversion Entry Attributes.
Relationships and Foreign Key Attributes.
Dependent and Independent Entities.
Identifying Relationships.
Non-Identifying Relationships.
Rolenames.
Naming and Defining Entities and Attributes.
Overview.
Entity and Attribute Names.
Synonyms, Homonyms, and Aliases.
Entity Definitions.
Descriptions.
Definition References and Circularity.
Business Glossary Construction.
Attribute Definitions.
Validation Rules.
Rolenames.
Definitions and Business Rules.
Model Relationships.
Relationships.
Relationship Cardinality.
Cardinality in Non-Identifying Relationships.
Referential Integrity.
Referential Integrity Options.
RI, Cardinality, and Identifying Relationships.
RI, Cardinality, and Non-Identifying Relationships.
Additional Relationship Types.
Many-to-Many Relationships.
N-ary Relationships.
Recursive Relationships.
Subtype Relationships.
Complete Compared to Incomplete Subtype Structures.
Inclusive and Exclusive Relationships.
IDEF1X and IE Subtype Notation.
When to Create a Subtype Relationship.
Normalization Problems and Solutions.
Normalization.
Overview of the Normal Forms.
Common Design Problems.
Repeating Data Groups.
Multiple Use of the Same Attribute.
Multiple Occurrences of the Same Fact.
Conflicting Facts.
Derived Attributes.
Missing Information.
Unification.
How Much Normalization Is Enough.
Support for Normalization.
First Normal Form Support.
Second and Third Normal Form Support.
Physical Models.
Objective.
Support for the Roles of the Physical Model.
Summary of Logical and Physical Model Components.
Denormalization.
Appendix A: Dependent Entity Types.
Classification of Dependent Entities.
Glossary.
Index.
