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 from this section introduction that relational data modeling is the process of capturing how the business works by precisely representing business rules, while dimensional data modeling is the process of capturing how the business is monitored by precisely representing navigation. There are both relational and dimensional conceptual data models.

The relational conceptual model includes concepts, their definitions, and the relationships that capture the business rules binding these concepts. Unlike the logical and physical data models, as we will see, conceptual models may contain many-to-many relationships. For example, Figure 8.3 contains part of a financial relational ...

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