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

In previous chapters, we created entities, submodels, attributes, and keys for our publishing example. Now lets relate the entities to each other. Convert the following business assertions into relationships on our data model (remember to add the verb phrase and make sure it appears on the diagram):

·         Each Offering can be a Title, Conference, or Seminar.

·         Each Title is an Offering.

·         Each Conference is an Offering.

·         Each Seminar is an Offering.

·         Each Author may write one or many Titles.

·         Each Title must be written by one or many Authors.

·         Each Title can be an Electronic Title or a Print Title.

·         Electronic Title is a Title

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