Data Modeling Made Simple with PowerDesigner

This book will provide the business or IT professional with a practical working knowledge of data modelling concepts and best practices, and how to apply these principles with PowerDesigner. You will build many PowerDesigner data models along the way, increasing your skills in first the fundamentals and later in the book the more advanced features of PowerDesigner. The book contains six sections: Section I introduces data modelling along with its purpose and variations. Also included is an explanation of the important role of a data modelling tool, the key features required of any data modelling tool, and an introduction to the essential features of PowerDesigner. Section II explains all of the components on a data model including entities, data elements, relationships, and keys, and describes how to create and manage these objects in PowerDesigner. Also included is a discussion of the importance of quality names and definitions for your objects. Section III dives into the relational and dimensional subject area, logical, and physical data models, and describes how PowerDesigner supports these models and the connections between them. Learn how to get information into and out of PowerDesigner, and improve the quality of your data models with a cross-reference of key PowerDesigner features with the Data Model Scorecard. Section IV contains a PowerDesigner workshop designed to consolidate everything for you. Section V focuses on additional PowerDesigner features (some of which have already been introduced) which make life easier for data modellers. Section VI discusses PowerDesigner topics beyond data modelling, including the XML physical model and the other types of model available in PowerDesigner. It also discusses the role of PowerDesigner in data management, using the DAMA Data Management Body of Knowledge (DAMA-DMBOK) framework.