O'Reilly logo

Data Modeling Made Simple with CA ERwin Data Modeler r8 by Steve Hoberman, Donna Burbank

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Let’s go back to our Baker Cakes example. In the last chapter, we created a Conceptual data model, shown again for reference in Figure 18.20, to define the core business concepts and relationships of the organization. We’ll now want to refine the model, and add more detail.

Figure 18.20 Relational Conceptual Model for Baker Cakes

Let’s use this Conceptual model as a starting point for our ‘top-down’ design. If you don’t have it handy, you can download a sample Baker Cakes Conceptual.erwin model from www.erwin.com/datamodelingmadesimple.

To derive a logical model from the conceptual model we created, select Actions|Design ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required