Define triggering operation. Provide an example and include the components
What will be an ideal response?
A triggering operation (also called a trigger) is an assertion or rule that governs the validity of data manipulation operations such as insert, update, and delete. The scope of triggering operations may be limited to attributes within one entity or it may extend to attributes in two or more entities. Other examples may be used.
Example:
User rule: WITHDRAWAL Amount may not exceed ACCOUNT Balance
Event: Insert
Entity Name: WITHDRAWAL
Condition: WITHDRAWAL Amount > ACCOUNT Balance
Action: Reject the insert transaction
You might also like to view...
Which of the following is an example of an estimable probable contingency?
A) FICA Taxes Payable B) Income Taxes Payable C) Warranty Payable D) Accounts Payable
The choice between demonstration, slice-of-life, straight sell, and other advertising forms is a matter of the:
A) creative strategy. B) advertising appeal. C) selling proposition. D) creative execution. E) big idea.