Data Modeling with ERwin

• Modeling core entities, which represent the business-critical objects of an enterprise
  
• Selecting ERwin tools according to the chosen methodology and whether the model is in logical or physical mode
  
• Creating, modifying, and deleting subject areas in the diagram with the Subject
• Area Editor
  
• Selecting and saving a set of diagram display options and display levels for the subject area with the Stored Display Editor
  
• Creating user-defined properties for model objects with ERwin's UDP Editor
  
• Defining the components of the physical model and setting the physical modeling environment in ERwin
  
• Using ERwin's logical only and physical only properties
  
• De-normalizing the physical model to meet usage requirements and improve performance
  
• Creating, modifying, and deleting indexes with ERwin's Index Editor
  
• Reviewing the physical data model to ensure that it fulfills information requirements and business rules, and meets the usage requirements and the platform specifications of your enterprise
  
• Generating the physical model objects in the target server

Table of contents

Introduction

Part I: Modeling Concepts

1: Understanding Data Modeling Concepts

2: Understanding Entities

3: Understanding Attributes

4: Understanding Relationships

Part II: Introducing ERwin

5: Getting Started with ERwin

6: Introducing ERwin's Menus and Tools

7: Reverse Engineering and Report Generation in ERwin

8: Discovery: Gathering Information Requirements, Metadata, and Business Rules

Part III: Creating the Logical Model

9: Developing the Logical Data Model

10: Building Logical Relationships

11: Organizing and Enhancing the Logical Data Model

12: Reviewing the Logical Data Model

13: Delivering the Logical Data Model

14: Advanced Features for the Logical Model

Part IV: Creating the Physical Model

15: Developing the Physical Model

16: Building the Physical Model in ERwin

17: Building Physical Relationships

18: Reviewing the Physical Data Model

19: Delivering the Physical Data Model

20: Advanced Features for the Physical Model

References

Index