Task 3: Database Trigger (5 marks) Triggers are used to implement complex business rules. Spoc Bank has some rules that have not been outlined earlier. One of them concerns the number of loans customers can have. The rules are: a) b) A customer cannot individually have more than five loans. The maximum number of loans that a customer can have, including both individual and joint loans, is eight. c) A customer cannot have more than one personal loan. d) Total amount of all the loans that an individual is involved in cannot exceed 10 million dollars. This calculation takes into account the original loan amounts, not the remaining loan balances An individual cannot be involved in more than three home loans. e) You have decided to implement these rules by writing a trigger. (i Explain what sort of trigger you would use for this purpose, and why. ( Discuss how you will test this trigger. (ii) write and adequately test this trigger. Task 3: Database Trigger (5 marks) Triggers are used to implement complex business rules. Spoc Bank has some rules that have not been outlined earlier. One of them concerns the number of loans customers can have. The rules are: a) b) A customer cannot individually have more than five loans. The maximum number of loans that a customer can have, including both individual and joint loans, is eight. c) A customer cannot have more than one personal loan. d) Total amount of all the loans that an individual is involved in cannot exceed 10 million dollars. This calculation takes into account the original loan amounts, not the remaining loan balances An individual cannot be involved in more than three home loans. e) You have decided to implement these rules by writing a trigger. (i Explain what sort of trigger you would use for this purpose, and why. ( Discuss how you will test this trigger. (ii) write and adequately test this trigger