>SQL Assignment (See Attachment)This assignment is on SQL I need to make some triggers and a store procedure. I actually only need help for 7 of the questions listed. I do not believe this will take long: (b) MySQL Trigger Syntax is as follows: DELIMITER $$ CREATE TRIGGER trigger_name trigger_time trigger_event ON table_name FOR EACH ROW BEGIN … END$$ DELIMITER ; The structure of the table: employee (3). Create an index “IndLastFirstName” with columns LAST_NAME and FIRST_ NAME on employee table. (See document for table pic) (4). List the query which will use the index “IndLastFirstName” a) Select * from employee where FIRST_ NAME=’Joe’ b) Select * from employee where LAST_NAME =’LEE’ c) Select * from employee where LAST_NAME =’LEE’ and FIRST_ NAME=’Joe’ d) Select * from employee where LAST_NAME =’LEE’ orFIRST_ NAME=’Joe’ The structure of the table: Customers (b) Can you create a function to implement the above if “yes” write the function if “no” explain the reason? Table: STUDENT_MAST: create table t_test (id int not null primary key) engine=InnoDB; Start transaction; insert into t_test values(1); insert into t_test values(3); savepoint tran1; insert into t_test values(2); UPDATE STUDENT_MAST SET ST_CLASS=10 WHERE STUDENT_ID=2; rollback to tran1; UPDATE STUDENT_MAST SET ST_CLASS=17 WHERE STUDENT_ID=3; UPDATE STUDENT_MAST SET ST_CLASS=18 WHERE STUDENT_ID=4; Commit; After executing the SQL transactions above please answer: (Please see the attached document for the tables and correct formatting)