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

Technics Publications needs a reporting application to track book sales. The data models we build through this chapter and the next two will be used as the design for a book sales analytics system, where book sales can be tracked by different parameters.

For this exercise, create a dimensional CDM to track book sales at the level of month, region, and title, and then allow navigation from month to quarter and year, from region to country, and from title to category.

Create two separate data models in ER/Studio, one built using information engineering notation and the other dimensional notation. Recall that when we create a new data model, we are given a choice from a drop down whether ...

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