The data model scorecard contains more than 400 rules to apply when reviewing a data model. One of these rules requires justifying optionality on a relationship. For example, on the model in Figure 1  we have these two business rules:

The circle on the relationship line implies zero. That is, a Customer can exist without ever placing an Order. In this example, we would ask the modeler the question, "When can a Customer exist without having placed an Order?"

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access