Are Integrity Constraints Business Rules? Not!

Ronald G.  Ross
Ronald G. Ross Co-Founder & Principal, Business Rule Solutions, LLC , Executive Editor, Business Rules Journal , and Co-Chair, Building Business Capability (BBC) Read Author Bio       || Read All Articles by Ronald G. Ross

Database professionals are prone to equating 'integrity constraint' with 'business rule'.  Are they the same?  Probing deeper, it's generally accepted that any integrity constraint can be violated -- indeed, the reason you define them is to prevent that very thing from happening.  Can all business rules be violated?  Is violating an integrity constraint the same as violating a business rule?

To make sense of these questions, consider the following sample rules.

  1. A barred driver must not have possession of a rental car. 

    This is an operative (behavioral) rule.  It can be violated in real life for a variety of reasons -- e.g., theft.  In the real world, unfortunately you can't always prevent that from happening.  This sample is a true business rule -- it is relevant to the business without any mention of a system.

  2. A car rental always has a rental customer. 

    This is a structural (definitional) business rule.  The sense of this rule is that something simply isn't a car rental without a rental customer -- by definition.  You can't really violate a rule that establishes whether something is or is not something by definition.  That's just the way it is.  Nonetheless, this sample is also a true business rule -- it is again relevant to the business without any mention of a system.

  3. A customer record may include at most one phone number.  

    This case is fundamentally different.  There's generally no such rule in real life or business -- someone has made a (database) design decision in the form of a rule.  A system can prevent violations in the data, but certainly not in real life.  This is a system rule, not a business rule.

So which of the samples above are integrity constraints?  Obviously the third is.  With some translation work, perhaps the first and second could become ones too.  But they would need to become more data-ish first.  And that's the key difference.  Business rules always have to do with the conduct and decisions of people; integrity constraints and system rules always have to do with the integrity of data.  That's a big difference!

Also note that in contrast to integrity constraints, not all business rules can be violated.  The reason is that some business rules (e.g., the second above) have to do with the way people understand concepts and make decisions.  You can misapply such rules, but you really can't violate them per se.

To emphasize these points, let's examine two more sample rules.

  • A rental can have at most two drivers.

    This operative rule forbids the customer to put the third driver behind the wheel.  In the real world, it obviously can be violated.  There is simply no way to prevent it.

  • A rental can have at most two recorded drivers.

    This is a system rule.  If the rental record has only two slots, it is not possible to record a third driver.  Violations can be prevented -- because they are data violations, not people violations.  This integrity constraint is a data-recording (i.e., system) rule.
The business rules approach makes a clear distinction between these two cases.  It prescribes looking first at rules from a business point of view, then at the rules from a data-recording point of view (whether by computer, pencil-and-paper, abacus, etc.).  If you can't get the former right, you'll never get the latter right.  By the way, getting the former right doesn't guarantee you will get the latter right -- it just gives you the best possible chance.

In my experience, failing to appreciate the distinctions between business rules and system rules or integrity constraints is a root cause of many IT 'requirements' problems.  A customer record may include only one phone number.  The system may record only two driver names in the record of a car rental.  Integrity constraints probably, but not business rules!

# # #

Standard citation for this article:


citations icon
Ronald G. Ross , "Are Integrity Constraints Business Rules? Not!" Business Rules Journal Vol. 8, No. 3, (Mar. 2007)
URL: http://www.brcommunity.com/a2007/b335.html

About our Contributor:


Ronald  G. Ross
Ronald G. Ross Co-Founder & Principal, Business Rule Solutions, LLC , Executive Editor, Business Rules Journal , and Co-Chair, Building Business Capability (BBC)

Ronald G. Ross is Principal and Co-Founder of Business Rule Solutions, LLC, where he actively develops and applies the IPSpeak methodology including RuleSpeak®, DecisionSpeak and TableSpeak.

Ron is recognized internationally as the "father of business rules." He is the author of ten professional books including the groundbreaking first book on business rules The Business Rule Book in 1994. His newest are:


Ron serves as Executive Editor of BRCommunity.com and its flagship publication, Business Rules Journal. He is a sought-after speaker at conferences world-wide. More than 50,000 people have heard him speak; many more have attended his seminars and read his books.

Ron has served as Chair of the annual International Business Rules & Decisions Forum conference since 1997., now part of the Building Business Capability (BBC) conference where he serves as Co-Chair. He was a charter member of the Business Rules Group (BRG) in the 1980s, and an editor of its Business Motivation Model (BMM) standard and the Business Rules Manifesto. He is active in OMG standards development, with core involvement in SBVR.

Ron holds a BA from Rice University and an MS in information science from Illinois Institute of Technology. Find Ron's blog on http://www.brsolutions.com/category/blog/. For more information about Ron visit www.RonRoss.info. Tweets: @Ronald_G_Ross

Read All Articles by Ronald G. Ross

Online Interactive Training Series

In response to a great many requests, Business Rule Solutions now offers at-a-distance learning options. No travel, no backlogs, no hassles. Same great instructors, but with schedules, content and pricing designed to meet the special needs of busy professionals.