DATA MODELING WITH POWERDESIGNER 16.7 (PWD2)

Course content:

• SAP PowerDesigner
1. Identifying key components of the PowerDesigner environment
2. Creating a project in the workspace

• Conceptual Data Models (CDMs) and Logical Data Models (LDMs)
1. Applying model properties and options
2. Creating entities and domains
3. Creating relationships in CDMs and LDMs
4. Creating inheritance links in a model
5. Validating a CDM

• Physical Data Models (PDMs)
1. Generating a PDM from another model
2. Implementing data integrity checks in a PDM
3. Creating views, stored procedures, and triggers
4. Creating indexes and alternate keys
5. Validating a PDM
6. Generating a database from a PDM
7. Reverse engineering from an existing database

• Model Synchronization
1. Comparing models
2. Merging models
3. Synchronizing models

• Model Organization
1. Creating and modifying a package
2. Creating a diagram
3. Creating a package from a diagram
4. Creating a dependency matrix

• Reporting
1. Creating a report template
2. Creating a report
3. Generating a report
4. Creating a multi-model report

• Impact Analysis
1. Creating requirements
2. Linking models
3. Generating an Impact Analysis Model (IAM)

• The Repository
1. Creating a glossary
2. Modifying documents in the repository
3. Setting up a repository workflow
4. Integrating changes across repository branches
5. Managing a repository