Following is a brief summary of the ten steps to complete a Conceptual Model (for more on this approach, please refer to Data Modeling for the Business: A Handbook for Aligning the Business with IT using High-Level Data Models, ISBN 9780977140077). We’ll relate each of these ten steps to our fictional company, Baker Cakes, a small corporation whose focus is the sale and production of specialty decorated cakes, and show how a conceptual model helps them define their business requirements for a new application they’re building.

1.      Identify model purpose. Before starting any data modeling effort, first identify why the model needs to be built. The underlying reason for building a data model is communication. ...

Get Data Modeling Made Simple with CA ERwin Data Modeler r8 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.