Answered step by step
Verified Expert Solution
Question
1 Approved Answer
if we wish to monitor changes to grade in the Enroll table, we could first set up a table to hold the audit records.
if we wish to monitor changes to grade in the Enroll table, we could first set up a table to hold the audit records. What would be the schema for this new table? b) Creat a trigger that will audit UPDATES in the column GRADES of the table ENROLL. Enroll(stuld, classNumber, grade)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Schema for the audit table auditgradechanges auditid INT NOT NULL AUTOINCREMENT enrollid INT NOT NUL...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Auditing A Practical Approach
Authors: Robyn Moroney, Fiona Campbell, Jane Hamilton
4th Edition
0730382648, 978-0730382645
