Sunday, January 24, 2016

DIFFERENCES BETWEEN RELATIONAL INTEGRITY CONSTRAINTS AND BUSINESS CRITICAL INTEGRITY CONSTRAINTS


Relational integrity constraints
Business critical integrity constraints
1. Rules that enforce the basic and fundamental information constraints.
1. Enforce rules geared towards the goals and success of the business.
2. For example, a supplier might put a constraint on the amount of time that a product might be returned due to the fact that it will spoil after a certain amount of days. This kind of constraint mirrors the rules by which a company achieves success.
2. For example, this constraint wouldn’t allow an employee to enter an order or a customer that doesn’t exist in the system or order a negative amount of goods from a supplier.

No comments:

Post a Comment