Write a trigger to update the CUST_BALANCE when an invoice is deleted. Name the trigger trg_updatecustbalance2. (You should delete INV_NUM 9006 from INV_MYSQL to ensure your code is correct.)

What are the INSERT TRIGGER, DELETE TRIGGER and UPDATE TRIGGER. Explain with examples.

First, create (Clone) another version of DEPARTMENTS table with Create table as select command .something like this below. CREATE TABLE new_departments AS SELECT * FROM hr_DEPARTMENTS WHERE 1=2;  This unmatcheched WHERE condition will be able to create same table as DEPARTMENT but no data in it. Empty version. Create a PL/SQL block that selects the record which belongs to maximum department ID in the hr_departments table and stores entire record info to composite variable as RECORD. (Lets say cv_dept) Create this composite variable same ROWTYPE of DEPARTMENT table. Declare a variable, v_max_deptno , of type NUMBER in the declarative section. Start the executable section with the BEGIN keyword and include a SELECT statement to retrevive the maximum department_id from the departments table. By using this v_max_deptno use this number in WHERE condition of SELECT statement and make sure you only bring one row from DEPARTMENTS table to composite variable. You will now INSERT this max…

A summarize table can be edited in Transform Data? True False

Insert the following records into their corresponding tables, using the MySQL CLI. Take a screenshot of a Select * command being successfully executed on each table (6 total).  Subject   subjectNumber Name gradeLevel 62 Algebra 9 33 Biology 10 83 Legal Studies 11 35 Entomology 9 70 Norse Mythology 10 23 Geography 10 67 Literature 12 78 World History 11 13 US History 12 9 Astronomy 9 53 Self Defense 12 85 Introduction to Computer Science 11 43 Algebra II 10

Hi triggers Update and using Xampp and this table: CREATE TABLE MEMBER(STUDENT_ID CHAR(6) NOT NULL,CLUB_CODE VARCHAR(4) NOT NULL,MEMBER_DATE DATE NOT NULL,MEMBER_POSITION VARCHAR(15) NOT NULL,MEMBER_ATTENDANCE CHAR(2) NOT NULL,PRIMARY KEY (STUDENT_ID,CLUB_CODE),FOREIGN KEY (STUDENT_ID) REFERENCES STUDENT (STUDENT_ID) ON DELETE RESTRICT ON UPDATE CASCADE,FOREIGN KEY (CLUB_CODE) REFERENCES CLUB (CLUB_CODE) ON DELETE RESTRICT ON UPDATE CASCADE); INSERT INTO MEMBER VALUES('100027','C201','2020-03-25','Secretary','12'),('100027','C202','2020-04-11','Member','11'),('100032','C201','2020-02-23','President','12'),('100050','C201','2020-03-25','Member','10'),('100132','C202','2020-04-11','Treasurer','10'),('100074','C203','2020-04-09','President','12'),('100074','C204','2020-04-25','Treasurer','12'),('100051','C204','2020-04-25','Member','9'),('100064','C207','2020-04-25','Vice…