How Relationships Conform to Relationship Types

When you store a relationship, the meaning of what you store has three aspects:

• Which two objects are related to each other?

  For example, when you store the relationship indicating that Herman Melville wrote Moby Dick, you relate the object describing Herman Melville and the object describing Moby Dick.

• How are the two objects related?

  For example, when you store the relationship indicating that Herman Melville wrote Moby Dick, you indicate that Melville wrote the book, not that he reads it or criticizes it. You indicate that Melville wrote the book by creating a relationship that conforms to the Authorship relationship type.

• What role does each object play in the relationship?

  For example, when you store the relationship indicating that Herman Melville wrote Moby Dick, you indicate that Melville wrote Moby Dick, not that Moby Dick wrote Melville. The object representing Melville plays the role of the thing performing the writing, and the object representing Moby Dick plays the role of the thing that was written.

The following figures evaluate whether potential relationships conform to the two relationship types: Authorship (of book by person) and Publication (of book by publisher).

Potential relationship

Does the relationship conform?

Microsoft Press® publishes Inside OLE: Yes, the relationship conforms to the Publication relationship type.

Potential relationship

Does the relationship conform?

Kraig Brockschmidt publishes Inside OLE: No, the relationship does not conform to either relationship type. The Publication relationship type allows you to save a relationship indicating that a publisher publishes a book. This data indicates that a person publishes a book.

Potential relationship

Does the relationship conform?

Kraig Brockschmidt wrote Inside OLE: Yes, the relationship conforms to the Authorship relationship type.

Potential relationship

Does the relationship conform?

Inside OLE publishes Microsoft Press: No, the relationship does not conform to either relationship type. Although this relationship uses two objects of the correct type, it does not conform because it uses those objects in the wrong roles.

Potential relationship

Does the relationship conform?

Microsoft Press publishes Moby Dick: Yes, the relationship conforms to the Publication relationship type. The relationship conforms, even though the data is inaccurate. (Microsoft Press does not publish Moby Dick.)