course table colums:

- course_number

_course_name

-course_description

-instructor_id

 

 

 Make an audit table for the courses table in the courses database. You should create matching fields to store values we will pull from each of the four fields as well as fields to capture what types of changes are made and when. 2.Make a trigger for this table that will be called whenever an update is made on the table. When this occurs, we want to store the change in the audit table with 2 rows. One that shows what the row in the courses table was changed FROM and one that shows what the row was changed TO. This trigger should also appropriately populate the type of change field and the date field. 3. Use an update statement to change one of the rows in the courses table. Change the description to something new. Then, see your audit table to see the new rows that have been created. 4. Use the appropriate command to ensure that the event scheduler is turned on. If it isn't already, turn it on. 5. Make an event that will run every day at 9 pm to clear out the audit table. 6. Use the show events command to show the active events in the database