Reporting” database was created and populated with sample data.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

OVERVIEW

In the Research Project: Part 1 – Create Expense Table Assignment, the “Expense 

Reporting” database was created and populated with sample data. In the Research Project: Part 2 – Create a Business Report Assignment, you will write relevant business reports, views, an index, a trigger, and create a security management structure.  See the deliverables of Research Project: Part 2 below in the instructions area. The body of the paper must include biblical integration.  More specially, write about how Christian worldview perspectives can be integrated when solving database problems. Finally, provide a comprehensive description of the Biblical implications of database systems.

 

INSTRUCTIONS

 

1. Reports (For each report, a screenshot and a short statement that describes the business purpose is required) 

• Include 4 aggregate functions 

• Include 2 joins with 2 or more tables 

• Include 2 nested queries 

 

2. Indexes, Views and Trigger (For each report, a screenshot and short statement that describes the business purpose of the index and trigger is required) 

• Create a view (ERClerkView) that joins the ExpenseReport and ExpenseItem tables. The view must only retrieve expense reports with a status of PENDING. 

• Create a view (Org1SummaryView) of the BudgetItem table for organization number 1. The view must contain the sum of the actual and budgeted amounts by year and expense category number. Restrict the rows to organization 1. 

• Include 1 index 

• Include 1 trigger 

 

3. Role and User Creation (For each report, screenshots and SQL statements or SQL 

Management Studio user interface is required) 

• Create roles named ERClerk and Org1Mgr. 

• Create users named ERClerk1 and Org1Mgr1. 

• Grant the ERClerk role the ability to select ERClerkView. 

• Grant the Org1Mgr role the ability to select Org1SummaryView. 

• Grant user ERClerk1 the role of ERClerk and user Org1Mgr1 the role of Org1Mgr. 

 

Note: Your assignment will be checked for originality via the Turnitin plagiarism tool.

 

 

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of