a$.$ Write Database Triggers for Successful Insert Message

$--$ Trigger for Employee table insert

CREATE TRIGGER trg$\_$Insert$\_$Employee

AFTER INSERT ON Employee

FOR EACH ROW

BEGIN

SIGNAL SQLSTATE $\text{'}45000\text{'}$ SET MESSAGE$\_$TEXT $=$ 'Record Inserted in Employee Table';

END;

$--$ Trigger for Department table insert

CREATE TRIGGER trg$\_$Insert$\_$Department

AFTER INSERT ON Department

FOR EACH ROW

BEGIN

SIGNAL SQLSTATE $\text{'}45000\text{'}$ SET MESSAGE$\_$TEXT $=$ 'Record Inserted in Department Table';

END;

b$.$ Trigger for Budget Check

CREATE TRIGGER trg$\_$Budget$\_$Check

BEFORE INSERT ON Project

FOR EACH ROW

BEGIN

IF NEW.Budget $>50000$ THEN

SIGNAL SQLSTATE $\text{'}45000\text{'}$ SET MESSAGE$\_$TEXT $=$ 'The Budget is over $50,000\text{'}$;

END IF;

END;

c$.$ Trigger for Delete Message

$--$ Trigger for Working$\_$Project table delete

CREATE TRIGGER trg$\_$Delete$\_$Working$\_$Project

AFTER DELETE ON Working$\_$Project

FOR EACH ROW

BEGIN

SIGNAL SQLSTATE $\text{'}45000\text{'}$ SET MESSAGE$\_$TEXT $=$ 'Delete Done from Working$\_$Project';

END;

$--$ Trigger for Project table delete

CREATE TRIGGER trg$\_$Delete$\_$Project

AFTER DELETE ON Project

FOR EACH ROW

BEGIN

SIGNAL SQLSTATE $\text{'}45000\text{'}$ SET MESSAGE$\_$TEXT $=$ 'Delete Done from Project';

END;

d$.$ Trigger for Hours Exceeding KPI

CREATE TRIGGER trg$\_$Working$\_$Project$\_$Hours

BEFORE INSERT ON Working$\_$Project

FOR EACH ROW

BEGIN

IF NEW.hours $>24$ THEN

SIGNAL SQLSTATE $\text{'}45000\text{'}$ SET MESSAGE$\_$TEXT $=$ 'Project Exceed KPI';

END IF;

END;