Relational Concepts  «Prev  Next»

Lesson 4Introduction to business rules
ObjectiveDefine what Business Rules are and why they are necessary

Business Rules and why they are necessary

A business rule is a condition that reflects a specific business need, which the software must accommodate. The ability to accommodate business rules is critical to any software product’s effectiveness.

Enforcing Business Rules

Business rules are enforced within MS SQL Server 2012 in a variety of ways:
  1. Primary keys
  2. Foreign keys
  3. Rules
  4. Defaults
  5. Triggers
  6. Stored procedures
  7. Constraints

Importance of business rules

Business rules can be quite complex, which is why there is no single way to enforce them. It is imperative that you understand and document the rules that govern how a company does business. This ensures that there are no “holes” in the system that bypass a business rule. Business rules also enforce data integrity. For example, suppose the business has a rule that states the following:
No employee shall have a salary of $100,000/yr or greater if they are at or below a paygrade of L-3.”
This business rule can be enforced by a variety of means, such as a Trigger, Stored procedure, or constraint. However, there are potential implications of using each of these database objects.
All of the types of database objects listed above are discussed throughout this course and the other courses in this series. This introduction serves as the “jumping off point” for getting you to think in terms of business rules.
In the next lesson, we will cover primary keys and unique constraints.