if we wish to monitor changes to grade in the Enroll table, we could first set...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Answer rating: 100% (QA)
Schema for the audit table auditgradechanges auditid INT NOT NULL AUTOINCREMENT enrollid INT NOT NUL... View the full answer
Related Book For
Auditing A Practical Approach
ISBN: 9780730382645
4th Edition
Authors: Robyn Moroney, Fiona Campbell, Jane Hamilton
Posted Date:
Students also viewed these databases questions
-
Diane is the owner of a CCPC. While her business is doing extremely well, she consistently has bad luck with her investments, accumulating large property losses. She plans to eventually sell her CCPC...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
If we wish to accumulate $8,000 by the end of 4 years, how much should the annual payments be if we receive an interest rate of 10% on our investments? The first payment is made at the end of each...
-
To pick up the execution results, one can use the executeQuery() and executeUpdate() methods. The former returns an integer, and the latter returns a ResultSet.(True/False)
-
The virtual image produced by a convex mirror is one-third the size of the object. (a) If the object is 27 cm in front of the mirror, what is the image distance? (b) What is the focal length of this...
-
Net exports and foreign demand a. Suppose there is an increase in foreign output. Show the effect on the domestic economy (i.e., replicate Figure 18-4). What is the effect on domestic output? On...
-
Assuming the same information in Brief Exercise 18-25, record the income tax journal entry on December 31, 2020. Assume zero beginning balances in deferred tax accounts and there are no other...
-
1. What is the total annual cost of the present ordering policy for part number 650810/ss/R9/o? 2. What would be the lot size for part number 650810/ss/R9/o if FabQual were to use an economic order...
-
Exercise 10-14A (Algo) Cost of goods manufactured and sold LO 10-5 The following information pertains to Flaxman Manufacturing Company for April. Assume actual overhead equaled applied overhead....
-
When you think of political persuasion, you may think of the effortsthat political campaigns undertake to persuade you that their candidate is betterthan the other candidate. In truth, campaigns are...
-
A firefighter, whose mass (including clothing and equipment) is m= 92 kg, hears the alarm and slides down the pole with a constant downward acceleration of magnitude a=3.04 m/s 2 What is the...
-
Explain the IFRS treatment of event after reporting period and critique it.
-
HOW MANY WORKERS ARE NEEDED TO ACHIEVE TARGET LABOUR COST?
-
Prepare a depreciation schedule assuming actual mileage was: 2 0 2 2 , 2 4 0 0 0 ; 2 0 2 3 , 2 8 0 0 0 ; 2 0 2 4 , 2 3 0 0 0 ; 2 0 2 5 , 1 7 0 0 0
-
Another investment of Sound is its 4 5 % interest in Pits Mining Corporation ( Pits ) . This investment was the outcome of a takeover attempt by Sound two years ago. Sound was frustrated in its...
-
How do ethical dilemmas and moral decision-making processes influence organizational behavior, and what frameworks can leaders utilize to promote ethical conduct and integrity within their...
-
A proposed cost-saving device has an installed cost of $795,000. The device will be used in a five-year project but is classified as three-year MACRS property for tax purposes. (MACRS schedule) The...
-
Pearl Medavoy will invest $10,240 a year for 20 years in a fund that will earn 10% annual interest. . If the first payment into the fund occurs today, what amount will be in the fund in 20 years? If...
-
Client closing procedures: (a) Are routine transactions that do not have an impact on audit risk. (b) Are the responsibility of those charged with governance who must ensure that transactions are...
-
Classification is an important assertion for expenses because: (a) There is often an incentive to overstate expenses. (b) Some expenses are subject to specific disclosure requirements. (c) Vouching...
-
Documenting internal controls: (a) Is always handled through the use of checklists and preformatted questionnaires. (b) Is done after internal controls are tested so that the results can be included...
-
In 2020, Adele Company accrued a legal liability of \(\$ 500,000\) for payments expected to be paid (and will be deducted when paid) as follows: 2021 : \(\$ 250,000 ; 2022\) : \(\$ 150,000\); and...
-
A plant asset purchased by Krest Inc. for \(\$ 100,000\) late in 2018 is to be depreciated as follows. In 2020 , taxable income was \(\$ 450,000\) and the tax rate is \(25 \%\). Future enacted tax...
-
The Billboard Company has a deferred tax liability in the amount of \(\$ 14,000\) at December 31, 2020, relating to a \(\$ 40,000\) installment sale receivable, \(\$ 20,000\) of which is collected in...
Study smarter with the SolutionInn App