Database Triggers

Problem

Every time an employee's salary is updated, you need to log the old and new salary in an audit table. Doing this in application code is risky because someone might bypass the API and update the DB directly. You decide to enforce it at the database level. Write a query that outputs concept with the value: "Triggers are stored programs that automatically execute in response to INSERT, UPDATE, or DELETE events."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution