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 logical data models.

You have seen examples of both relational and dimensional conceptual data models (recall Figures 8.3 and 8.5 from the chapter on conceptual data modeling), Figures 9.1 and 9.2 show these two examples at a logical level. Lets go through how each of these are built, starting with relational.

The relational logical data model includes ...

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