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 ...

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.