All of the following are relational integrity constraints, except
A) System will not allow an entry for an order for a non-existent customer
B) System will not allow returns of fresh produce after 15 days past delivery
C) System will not allow shipping a product to a customer who does not have a valid address
D) Systems will not allow shipping of a non-existent product to a customer

Question

Quizplus · Accepted Answer

The constraint in option B pertains to a business rule, not a relational integrity constraint. Relational integrity constraints are rules that ensure the consistency and accuracy of data within a database's tables, while business rules relate to the practices and policies of a particular company. Options A, C, and D are all examples of relational integrity constraints as they ensure that data in one table is consistent with data in another table.

All of the Following Are Relational Integrity Constraints, Except