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 publisher conceptual data model we built, repeated here in Figure 9.8. Descriptive information about each offering is entered on a shopping cart website, so people can buy books directly from the publisher. We are going to normalize the pieces of information on two screen prints from this shopping cart site.

Using the following publisher conceptual data model as a starting point, identify the attributes on the four screens from Figure 9.9, copied from the publisher website at www.TechnicsPub.com. Normalize these attributes to create a logical relational data model of the Offering Category area compare your answer to mine in the appendix.

Figure 9.8 Publisher CDM ...

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