|Here is a SQL standard trigger on relation R(a,b): |
CREATE TRIGGER T AFTER INSERT ON R REFERENCING NEW ROW AS Newtuple FOR EACH ROW WHEN(Newtuple.a * Newtuple.b > 10) INSERT INTO R VALUES(Newtuple.a - 1, Newtuple.b + 1);
When we insert a tuple into R, the trigger may cause another tuple to be inserted, which may cause yet another tuple to be inserted, and so on, until finally a tuple is inserted that does not cause the trigger to fire. Your problem is to examine the behavior of this trigger and determine under what circumstances exactly three tuples are inserted. Demonstrate your understanding by identifying, from the list below, which of the following tuples, if inserted into an initially empty relation R, results, after all instances of the trigger are allowed to execute, in exactly three tuples being present in R(a,b)?
Recently Asked Questions
- Phylogenies such as those above are properly understood by scientists to be
- Can you explain the difference between plasma membrane, cytosol, cytoskeleton and explain the function of the Golgi and what modification proteins go through
- Please refer to the attachment to answer this question. This question was created from assignment3.pdf. Additional comments: "could you write the python code