Use data control language (DCL) to control access to the

 

  • 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.
  • This is the last one finally! I attached the almost complete project so far for your awareness. Thank you SO MUCH!! and it has been a great experience.

Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!