Data Modeling with PowerDesigner 16

Goals

• Define glossary terms
• Distribute model templates using the Library
• Create and manage conceptual and logical data models
• Generate and manage physical data models
• Generate database creation scripts
• Produce implementation details, such as triggers, procedures, and views
• Reverse engineer an existing database to create physical, conceptual, and object-oriented models
• Compare and merge models
• Synchronize physical data models with databases
• Manage large models and multiple designers using the PowerDesigner Repository
• Create effective reports on you PowerDesigner models

Audience

• Data Analysts
• Data Modelers
• Database Administrators
• Systems Analysts
• Application Developers with Data Modeling responsibilities

Prerequisites

• * Understanding of relational database concepts and database implementation issues * Exposure to entity relationship (ER) data modeling and data normalization

Content

• Introduction to data modeling with PowerDesigner
• Using the PowerDesigner modeling environment
• Working with the Glossary and Library features
• Creating and managing a conceptual data model
• Defining business rules
• Creating data items, entities, and entity attributes
• Creating and defining relationships
• • Cardinality
  • Dependency
  • Roles
  • Existence
• Defining and using domains and inheritance
• Generating a physical data model
• Transforming CDM objects to PDM objects
• Customizing the physical data model
• Creating views, alternate keys, and indexes
• Creating the database script
• Protecting data through triggers, procedures, views, and business rule
• Reverse engineering databases
• Model management techniques
• Links to Requirements models
• Physical data model synchronization
• Working with packages and diagrams
• Working with the Enterprise Repository
• Creating reports

Notes

• Learn how PowerDesigner 16 can be used as a tool during the data analysis, data modeling, and database design processes. A well-known “best practice” in Information Engineering (IE) is to model the information at the conceptual , logical and physical levels. Employ PowerDesigner to create a conceptual and logical data models with entities, attributes, and relationships. Learn to target a DBMS, generate and enhance a physical data model, and then generate a database creation script for database tables, indexes, views, triggers, and stored procedures.
• You will also explore the reverse engineering features of PowerDesigner to create physical, logical and conceptual models from an existing database, as well as learn iterative modeling by using compare and merge model features and synchronizing physical data models with corresponding databases and vice versa. Additionally, learn how to use and mange Glossary, Library and Enterprise Repository for storing and sharing enterprise models across disparate groups and locations.

Popular tags

No tags submitted for this course yet