In this database question how can I write a trigger that does the following:

if the quantity of an item becomes less than 20, the a message is sent to the supplier.

I need help ASAP please.

Thank you for your consideration!

Using DDL. DML to create tables and constrants and any abjects required. Also use DML to insert and update, ec Create set of constraints in your database design We need to create database for supermarket in supermarket there are set of items each item has id name, price, quantry, production date and expired date Sometime there is discount for each ime, and the discount is not foxed, may be change from day to another day There are a lot of supplilers that supply the nems to supermarket each supplier has ID, Name, Address, Phone. Also there are set of cussomers, each customer has unique ID, name, phone. Customer buys set of hems and hen the cashier generate invoice for customer, the noice incued me amount of tax which it is 16% now and may be charged in rare. Each invoice has sequence number (ie. auto-number started from 1) The owner can generale report for sales for each cashier, and amount of tax for period to transter the money to tax office. Using DOL to create the tables, constraints and triggers