Rules on rules
Posted in Conceptual, Logical, and Physical Data Models, Data Quality and Data Governance, Rules and Cardinality
0 Comments

A logical data model represents a business solution independent of technology, including the business rules. For example, the rule, An order is identified by an order number and must have a valid ID from a customer and salesperson is enforced on the following model:
Yet there are other business rules such as the following that appear impossible to enforce on a logical data model:
A high-risk property is one that has had three or more claims filed in the last four years with a total value of more than $50,000 in losses.
What guideline do you apply in deciding which rules to enforce on the logical data model?