Learning Goal: I’m working on a mysql exercise and need an explanation and answe

Learning Goal: I’m working on a mysql exercise and need an explanation and answer to help me learn.You will use the iSchool database to answer the questions in this assignment. Please be sure that you have a pristine copy of the database on your server. If you have changed any values in any of the database tables, download and re-execute this creation script: create_iSchool.sqlFor Q1 you will complete a trigger, starting with this partially-created script: INST 327 – Assignment 7 – Trigger Partial Code.sql For Q2 you will complete a function, starting with this partially-created script: INST 327 – Assignment 7 – Function Partial Code.sqThe questions, instructions, and the files needed are included in this folder: https://drive.google.com/drive/folders/1w64gc25q_m…