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 products effectiveness.
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.