For this activity, write a 3-5 page paper that addresses the following:
Provide an example of a view, stored procedure or trigger.
Present the code and describe its purpose.
When would it be appropriate to use?
The example can be one you develop from scratch, use at your employment, or have located from some other source.
However, the code must be in Microsoft SQL server; please do not reference other DBMS Software.
If you cite an example from other sources, please list your reference.
Refer to the Module Exercises Rubric for grading criteria.
MGMT 392 4.2 Module Exercises Rubric
MGMT 392 4.2 Module Exercises Rubric
This criterion is linked to a Learning OutcomeIdentification and Analysis of the Main Issues/Problem
Excellent (A) (27-30) Identifies and understands all of the main issues in question. Insightful, and thorough analysis of all the issues.
Above-Average (B) (23-26) Identifies and understands most of the main issues in question. Thorough analysis of most of the issues.
Average (C) (19-22) Identifies and understands some of the issues in question. Superficial analysis of some of the issues in question.
Near-Failing (D) (15-18) Identifies and understands few of the issues in question. Incomplete analysis of the issues.
Failing (F) (0-14) Identifies and understands very little of the issues in question. No analysis of the issues.
This criterion is linked to a Learning OutcomeAnswers to Questions
Excellent (A) (27-30) Answers to questions are clear throughout. Connection with class and study material goes well beyond the obvious connections among ideas; demonstrates insight and original thinking.
Above-Average (B) (23-26) Answers to questions present some irrelevant information on topic etc., but very little; treatment goes beyond obvious connections with class and study material.
Average (C) (19-22) Answers to questions are vague in places; some irrelevant or distracting information.
Near-Failing (D) (15-18) Answers to questions are unclear and/or confusing. Treatment is very superficial; paper may be well written but says nothing.
Failing (F) (0-14) Does not address the questions. Treatment is very superficial and says very little.
This criterion is linked to a Learning OutcomeStrategy Choice and Justification
Excellent (A) (21-25) An appropriate, reasonable strategy is selected and successfully developed. Content knowledge is used correctly.
Above-Average (B) (17-20) An appropriate, reasonable strategy is selected and moderately developed. Content knowledge used appropriately, with minor computation errors.
Average (C) (13-16) An appropriate, reasonable strategy is selected, but minimally developed. Uses content knowledge with conceptual errors.
Near-Failing (D) (10-12) There is an attempt to solve the problem. Barely any strategy is applied that could lead to an answer. Rarely uses content knowledge.
Failing (F) (0-9) There is no attempt to solve the problem. No strategy is applied that could lead to an answer. Uses no content knowledge.
This criterion is linked to a Learning OutcomeCommunication, Style and Mechanics
Excellent (A) (13-15) Solution is presented in a clear and orderly manner so the reader can follow the flow of the solution and final answer.
Above-Average (B) (11-12) Solution is presented appropriately, but may contain a minor error. Reader can follow most of the steps in the solution and final answer.
Average (C) (9-10) Solution is presented appropriately, but contains conceptual errors. Solution is presented in an unclear manner. Scorer has difficulty following the sequence of steps.
Near-Failing (D) (7-8) Presents the problem in an unclear manner, steps are missing or out of sequence. Scorer cannot determine a sequence of steps.
Failing (F) (0-6) Does not present the problem in a manner that can be deciphered. Misuse of words throughout. Awkward sentences throughout. Difficult to attach a thought process. Poorly punctuated, misspelled words, grammatically abusive.
Total Points: 100.0
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 15% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post this is for a database management class and topic is database objects and microsoft sql appeared first on custom writings.
"Is this question part of your assignment? We Can Help!"