Answered: Slove this Q? a. Briefly discuss…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Slove this Q?

a. Briefly discuss database auditing. List at least four importance and at least three
objectives of database audit.

a. Muscat Funds is a company that provides loan to its members. A member can avail a
loan not more than 10,000 OMR. Muscat Funds management wants to record and
monitor any new loan granted which are more than 10,000 OMR. Write an audit
trigger command for the given scenario that will include the member id, type of loan,
granted loan amount, username and the date record has been added.

Your solution must include the necessary SQL commands and brief explanation for each
of the steps.
Note:
 Any object created should include student ID. For example, User2_15F1234. If the
user names are inappropriate, marks shall be deducted accordingly

Expert Solution

Step by step

Solved in 6 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions