Statement Requirements:

1.TRIGGER: Add a trigger to your check table (or equivalent) so that whenever a new sale of a menu item occurs (i.e. a new INSERT to Check Detail), automatically deduct the quantity from the quantity on hand of that item's inventory.

Transcribed Image Text:

CREATE TABLE THEATER( T_ID T_NAME T_CITY T_STATE T_THEME PRIMARY KEY (T_ID)); CREATE TABLE EMPLOYEE ( E_ID E_FNAME E_LNAME E_DOB E_ADDRESS E_CITY E_STATE E_ZIP E_PHONENUMBER CREATE TABLE MENU( ME_ITEMID ME_ITEM ME_CATEGORY ME SIZE ME ORDERQTY SQL SCRIPTS INTEGER VARCHAR(35) VARCHAR(20) CHAR(2) VARCHAR(20) CREATE TABLE MOVIE ( M_ID M_NAME M_TIME PRIMARY KEY (M_ID)); INTEGER VARCHAR(15) VARCHAR(15) DATE VARCHAR(30) VARCHAR(20) CHAR(2) CHAR(5) CHAR(12) DATE E_HIRED E_SALARY E_MNGID T_ID PRIMARY KEY (E_ID), FOREIGN KEY (T_ID) REFERENCES THEATER (T_ID)); INTEGER INTEGER, INTEGER INTEGER VARCHAR(50) VARCHAR(15) CHAR(2) INTEGER INTEGER CHAR(1) ME_QTYONHAND ME_RESTOCKLVL PRIMARY KEY (ME_ITEMID)); INTEGER VARCHAR(50) NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, TIME NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, CREATE TABLE THEATER( T_ID T_NAME T_CITY T_STATE T_THEME PRIMARY KEY (T_ID)); CREATE TABLE EMPLOYEE ( E_ID E_FNAME E_LNAME E_DOB E_ADDRESS E_CITY E_STATE E_ZIP E_PHONENUMBER CREATE TABLE MENU( ME_ITEMID ME_ITEM ME_CATEGORY ME SIZE ME ORDERQTY SQL SCRIPTS INTEGER VARCHAR(35) VARCHAR(20) CHAR(2) VARCHAR(20) CREATE TABLE MOVIE ( M_ID M_NAME M_TIME PRIMARY KEY (M_ID)); INTEGER VARCHAR(15) VARCHAR(15) DATE VARCHAR(30) VARCHAR(20) CHAR(2) CHAR(5) CHAR(12) DATE E_HIRED E_SALARY E_MNGID T_ID PRIMARY KEY (E_ID), FOREIGN KEY (T_ID) REFERENCES THEATER (T_ID)); INTEGER INTEGER, INTEGER INTEGER VARCHAR(50) VARCHAR(15) CHAR(2) INTEGER INTEGER CHAR(1) ME_QTYONHAND ME_RESTOCKLVL PRIMARY KEY (ME_ITEMID)); INTEGER VARCHAR(50) NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, TIME NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL, NOT NULL,