Problem
1. Suppose there are two relations r and s, such that the foreign key B of r references the primary key A of s. Describe how the trigger mechanism can be used to implement the on delete cascade option, when a tuple is deleted from s.
2. Write an assertion for the bank database to ensure that the assets value for the Perry ridge branch is equal to the sum of all the amounts lent by the Perry ridge branch.