Question: Suppose you wish to create an audit trail of changes to the takes relation. a. Define triggers to create an audit trail, logging the information

Suppose you wish to create an audit trail of changes to the takes relation.

a. Define triggers to create an audit trail, logging the information into a relation called, for example, takes trail. The logged information should include the user-id (assume a function user id() provides this information) and a timestamp, in addition to old and new values. Youmust also provides the schema of the takes trail relation.

b. Can the preceding implementation guarantee that updates made by a malicious database administrator (or someone who manages to get the administrator’s password) will be in the audit trail? Explain your answer.

Step by Step Solution

★★★★★

3.43 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Schema for the takes trail table Trigger for INSERT Trigger for UPDATE Tr... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Database System Concepts Questions!

Suppose you wish to sample n = 2 elements from a total of N = 10 elements. a. Count the number of different samples that can be drawn, first by listing them and then by using combinatorial...

Suppose you wish to approximate cos (/12) using Taylor polynomials. Is the approximation more accurate if you use Taylor polynomials centered at 0 or /6? Use a calculator for numerical experiments...

Suppose you wish to approximate e 0.35 using Taylor polynomials. Is the approximation more accurate if you use Taylor polynomials centered at 0 or ln 2? Use a calculator for numerical experiments and...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Could I get the answers to the multiple choice section of this? Thanks! Chapter 11 Introduction to Internal Control Systems True-False Questions 1. Controls that specifically encourage operating...

I need the multiple choice questions answers from chapter 4 and 5 of the attached & Monograph...

Part A - RECKON: The following Reports are to be produced using Reckon Accounting Software and you must upload the two Reports in PDF format to Turnitin: 1. Adjusted Trial Balance: (Reports...

I have an accounting assignment need to be finished asap. QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 1 2017 Integrated...

I know its a bit harsh but see if you can finish it in before tomorrow? thanks QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 2...

Hi, I need someone to do summary for the article I upload AUDITING: A JOURNAL OF PRACTICE & THEORY Vol. 28, No. 2 November 2009 pp. 1-34 American Accounting Association DOI: 10.2308 / aud.2009.28.2.1...

A mortgage can take up to 25 years to pay off. Taking a $250,000 home, calculate the month-end payment for 15-, 20-, and 25-year periods using semi-annually compounded interest rates of +%, 5.5%, and...

Frenchvanilla Company earned net income of $75,000 during the year ended December 31, 2012. On December 15, Frenchvanilla declared the annual cash dividend on its 5% preferred stock (par value,...

What is the key reason why a positive NPV project should be accepted? Multiple Choice 1 6 : 4 3 The present value of the expected cash flows equals the project's cost. The project's payback will be...

2. Explain: U.S. exports earn supplies of foreign currencies that Americans can use to finance imports. Indicate whether each of the following creates a demand for or a supply of European euros in...

Describe how to implement the queue ADT using two stacks as instance variables, such that all queue operations execute in amortized O(1) time. Give a formal proof of the amortized bound.

Consider a variant of Exercise C-7.29, in which an array of capacity N, is resized to capacity precisely that of the number of elements, any time the number of elements in the array goes strictly...

In Section 7.5.3, we demonstrated how the Collections.shuffle method can be adapted to shuffle a reference-type array. Give a direct implementation of a shuffle method for an array of int values. You...

What ietyen should investore kepect til earn en theise bofids

QUESTION 17 List and briefly explain the different forms of Efficient Market Hypothesis. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BIUS Paragraph v Arial 10pt ABC X X 11 "S +V - B AB...

Name Maturity Year Face Amount $(Mil) Current Price Coupon % Yield to Maturity % Market Value $ (Mil) Weight Weighted YTM % Senior Unsecured Debt (Foreign) 2032 600.00 100.667 1.300% 1.2404% Senior...