Computer Science Homework Help

I’m working on a databases discussion question and need an explanation and answer to help me learn.

Write a trigger that updates the attribute “avg_rating” automatically whenever a new
tuple is inserted into Watch. Please put your trigger at the end of the provided testbed and
insert more tuples into the Watch relation to test your trigger (make sure you add select
statements to show the output). Please care for MUTATING-TABLE Error