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

FUBES (fold up but easily separate) is an acronym I made up for a technique that uses the standard method of denormalizing while also allowing access to just the data elements from the parent side of a one-to-many relationship. There is an additional data element that contains a level code and additional instances for each of the parents. In Figure 19.5 for example, we have a subset of the logical data model for Calendar.

Figure 19.5 Subset of the Calendar Logical Data Model

Table 19.2 contains sample values for each of these entities.

Table 19.2 Sample values for Figure 19.5

Year

Year Code

Year Description Text

2007

Two Thousand Seven ...

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