Whenever a supplier's rating is increased, the cost of all parts supplied by that supplier must be increased by 10%. CREATE TRIGGER supRatingIncrease AFTER UPDATE ON Suppliers WHEN OLD.rating < NEW.rating FOR EACH ROW BEGIN UPDATE Catalog C SET C.cost = C.cost * 1.10 WHERE C.sid IN (SELECT C1.sid FROM Suppliers S1, Catalog C1 WHERE S1.sid = NEW.sid AND S1.sid = C1.sid); END