course table colums: - course_number _course_name -course_description -instructor_id Make an audit table for the courses
Fantastic news! We've Found the answer you've been seeking!
Question:
- 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
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: