Consider your life as a relational database and define 5 triggers and 5 stored procedures that would be useful in your life.

We recently learned about triggers and stored procedures.

Consider your life as a relational database and define 5 triggers and 5 stored procedures that would be useful in your life. Write pseudo-code for such triggers and/or stored procedures. For example:

CREATE OR REPLACE TRIGGER brush_my_teeth

BEFORE UPDATE OR INSERT ON sleep_tracker

FOR EACH ROW

BEGIN

IF :NEW.datetime_went_to_bed IS NOT null

AND :NEW.did_brush_teeth IS FALSE THEN

RAISE_APPLICATION_ERROR(-20010,’I must brush my teeth before going to bed’);

END IF;

END;