Business Management

 

 

 

 

1. Use excel, SQL queries, or any tool you want to use to perform analysis of the dba_audit_trail
for your specific users that clearly display the following results: (50 points)
a. How many updates and deletes were performed by each user you created for each
table. (Hint: A visual display pie chart, bar graph or similar, along with detailed
descriptions would satisfy this requirement.)
b. An x,y plot of the times each transaction was completed by each user on the
Projections2020 table. (Hint: You will have to experiment with this to get a meaningful
plot.) Be sure to describe and analyze the results.
c. A sequential list of SQL statements used against the Customers table for each user along
with the timestamps. Providing these results in a table will satisfy the requirement.

 

This question has been answered.

Get Answer