O'Reilly logo

Data Modeling Made Simple with ER/Studio Data Architect by Steve Hoberman

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

Recall the dimensional data model from earlier in this chapter, repeated here with slightly more detail, in Figure 9.10.

In a dimensional model, each table is assigned a Table Model type, which is distinguished by an icon displayed in the upper left corner of the entity or table box. You can further define a table in the Table Editor by assigning it a Table Type that displays at the bottom of the table (e.g. Fixed). The Table Type does not change how the data is handled but provides information to the reader about the data in the table. It is purely for documentation purposes.

 

Figure 9.10 Financial dimensional LDM

Account Balance is an example of a fact table (on a conceptual and logical data model ...

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