Create an Account

Already have account?

Forgot Your Password ?

Home / Questions / DB Administrative Tasks Database administration is an important element of database planning...

DB Administrative Tasks Database administration is an important element of database planning...

DB Administrative Tasks

 

 

Database administration is an important element of database planning. Security and performance issues need to be considered prior to the actual implementation of the database in the production environment. Write a Database Administration Plan document of 4–5 pages for the case study organization. Complete the following: •Use data control language (DCL) to control access to the data by writing structured query language (SQL) statements to add a group of 5 users who have been granted permission to perform specific system privileges (CREATE object) and object privileges (INSERT, SELECT, UPDATE, and EXECUTE). •Write the SQL-stored procedures that will support the efficient execution (using COMMIT and ROLLBACK) of 3 transactions (INSERT, UPDATE, and DELETE) in the database. •Generate an execution plan for each query created in the Week 4 IP and provide a performance analysis of the results of each plan. ?Provide a screenshot of the execution plan for each query. ?In your analysis, discuss which queries you would change, including how and why you would change the queries.

•Create a backup plan under the full recovery model and provide a rationale for your model. •Be sure to cite your sources in-text and in the References section by using APA style. •Add the Week 5 IP to the database system plan and complete the plan (incorporating feedback as needed).

 

 

May 14 2020 View more View Less

Answer (Solved)

question Subscribe To Get Solution

Related Questions