Datamodelling

[cssadhar]

Chapter 1: Data Modeling Concepts

• Data Modeling Development Cycle
• Data Modeling Standards
• Steps to Create a Data Model
• Data Modeler Role
• Enterprise Data Modeling
• Conceptual Data Modeling
• Logical Data Modeling
• Physical Data Modeling
• Data Modeling Reports using Erwin (Also covered in chapter 7)
• Logical V/s Physical Data Modeling
• Relational Data Modeling / OLTP
• Dimensional Data Modeling / OLAP
• Slowly Changing Dimensions / Different Types of SCD
• Relationships
• Data Model Versioning 

Chapter 2: Erwin Tool: The Information Management Solution!

• Database Design Made Easy
• Implement Enterprise-wide Design Standards
• ERwin's Benefits
• CA Modeling Suite Manages Application Development 

Chapter 3: The Premier Model Solution At Your Fingertips!

• How Do I Use ERwin?
• Before You Begin
• Target Databases Supported by ERwin 

Chapter 4: ERwin's New And Advanced Features!

• Introducing Product Enhancements
• What's New In ERwin?
• What's New In ERwin 7.3 or later?
• Flexible Support Of Multiple Model Types
• Adaptable Menu Structure
• The Model Explorer
• What Can You Do In The Model Explorer?
• Using The Model Explorer Context Menu
• Model Pane
• Subject Areas Pane
• Domains Pane
• Dockable Toolbars
• ERwin Toolbox
• Selecting, Moving, and Resizing Objects
• Alignment, Spacing, And Grouping Tools
• Drawing Tools

Chapter 5: Putting ERwin To Work!

• Working With Data Models
• What Is An Entity?
• What Is An Attribute?
• What Is A Relationship?
• What Is A Foreign Key?
• Creating A Data Model
• Enhance Your Data Model
• Splitting A Logical/Physical Data Model
• Derive A New Model
• Forward Engineering
• What's Next? 

Chapter 6: Jump Start Your Data Design Process!

• Use Existing Data To Build A New Model
• Reverse Engineering
• Using The Reverse Engineer Wizard
• Using ERwin's Complete Compare 

Chapter 7: Build Reports On Your ERwin Models!

• Learn What Report Builder Can Do 

Chapter 8: Using ERwin's Advanced Features!

• Working With Design Layers
• What Is A Design Layer?
• Other Design Layer Hierarchies
• Creating New Design Layers
• Creating New Design Layers
• Splitting A Model
• Deriving A Model
• Adding a Model Source
• What Is A Transform?
• Transform Toolbar
• Applying Transforms
• Expected Transform Results
• Transforms And The Model Explorer
• Resolving And Reversing Transforms
• Synchronizing Changes Between Design Layers
• Preserving Model History
• How to design Dimensional Model using Erwin

Chapter 9: Indexing and Partitioning Strategy using Erwin Tool and SQL Database