From the first chapter, author Carla DeAngelis skillfully explains the normally complex concepts of Data Modeling-a critical success factor in the information-based enterprises of today. Carla tackles complex topics such as Logical Data Models, Modeling Methodologies, Relationships, and Attributes in a clear style that makes it simple for anyone to begin applying them immediately. Once the foundation has been laid, Carla teaches you to develop your own databases with ERwin. You will learn to use the tool to create primary keys and assign attributes, build data relationships with point and click ease, build and edit tables with Erwin's built-in editors, create indexes with the Index Editor, write custom SQL scripts, and process reports with the Report Tools.
(NOTE: Each chapter concludes with a summary.)
ERwin and Data Modeling. Who Should Use This Book? Using This Book. Conventions Used in This Book.
I. MODELING CONCEPTS.
1. Understanding Data Modeling Concepts.
The Role of Data Modeling. Producing a Data Model. Taking an Enterprise View. Understanding Modeling Methodology.
2. Understanding Entities.
Introducing the Entity Relational Diagram. What Is an Entity? Defining Entity Types. Defining a Primary Key. Naming Entities. Describing Entities. Common Modeling Mistakes with Entities and Keys.
3. Understanding Attributes.
What Is an Attribute? Analyzing Attributes. Defining Attribute Characteristics. Defining Attribute Domains. Defining Attribute Optionality. Naming Attributes. Describing Attributes. Common Mistakes with Attributes.
4. Understanding Relationships.
What Is a Relationship? Defining Relationship Types. Relationship Cardinality. Relationship Optionality. Common Mistakes with Relationships.
II. INTRODUCING ERwin.
5. Getting Started with Erwin.
ERwin Features and Functionality. System Requirements for Installing Erwin. Installing Erwin. Opening and Closing Erwin. Setting the Modeling Environment. Diagram Display Options. Best Practice: Using Color for Meaning. Saving a Model.
6. Introducing ERwin's Menus and Tools.
Using the ERwin Menus. Introducing Object Editors. Other Menu Options. Introducing the ERwin Toolbox.
7. Reverse Engineering and Report Generation in ERwin.
Understanding Reverse Engineering. ERwin's Report Browser.
8. Discovery: Gathering Information Requirements, Metadata, and Business Rules.
Understanding Requirements Gathering. Gathering Information Requirements in Facilitated Sessions. Documenting Metadata. Documenting Business Rules.
III. CREATING THE LOGICAL MODEL.
9. Developing the Logical Data Model.
Building the Data Model in ERwin. Creating Entities. Adding Attributes. Using the Key Group Editor. Using the Domain Dictionary Editor.
10. Building Logical Relationships.
Logical Relationships in ERwin. Using the Relationship Tools. Using the Relationship Editor.
11. Organizing and Enhancing the Logical Data Model.
Subject Areas. Stored Displays. Display Options. Text Boxes. Icons.
12. Reviewing the Logical Data Model.
A Quality Logical Model. When Should the Model Be Reviewed? Who Should Review the Model? Preparing for the Logical Model Review. Reviewing the Logical Model. After the Logical Model Review.
13. Delivering the Logical Data Model.
Delivering Supporting Documentation. Delivering a Logical Model Diagram. Using the Print Model Dialog. Using RPTwin.
14. Advanced Features for the Logical Model.
User-Defined Properties. Domains. The ERwin Dictionary.
IV. CREATING THE PHYSICAL MODEL.
15. Developing the Physical Model.
Understanding the Physical Model. Understanding Usage Requirements. Setting the Physical Modeling Environment.
16. Building the Physical Model in ERwin.
Creating Tables in the Physical Model. Setting Table Properties. Setting Column Properties.
17. Building Physical Relationships.
Understanding Denormalization. Using the Volumetrics Editor. Creating Constraints. Creating Indexes. Building Views.
18. Reviewing the Physical Data Model.
Objectives of the Physical Model Review. Conducting the Physical Model Review. After the Physical Model Review.
19. Delivering the Physical Data Model.
Physical Model Documentation. Forward Engineering the Physical Model.
20. Advanced Features for the Physical Model.
Understanding ODBC Connections. Creating Database Objects in Access. Synchronizing Models and Databases.