Working with Data Models

The chapters in this part provide information about PowerDesigner features that allow you to check, generate from, and reverse-engineer to your data models .

• Checking a Data Model
  The data model is a very flexible tool, which allows you quickly to develop your model without constraints. You can check the validity of your Data Model at any time.
• Generating and Reverse-Engineering Databases
  PowerDesigner provides full support for round trip generation and reverse-engineering between a PDM and a database.
• Generating Other Models from a Data Model
  You can generate various types of PowerDesigner models from CDMs, LDMs, and PDMs.
• Working with SQL Statements in PowerDesigner
  Each object that you create in your model is associated with SQL code that can be used to create or modify it in your database schema, and which is displayed on the Preview tab of its property sheet. Certain objects also require that you write your own custom SQL statements.
• Migrating from ERwin to PowerDesigner
  You can easily import a model built with ERwin into PowerDesigner with no loss of metadata. PowerDesigner allows complete flexibility through reliable linking and synchronization between conceptual, physical and object-oriented model approaches, providing outstanding model clarity and flexibility.