logo Use CA10RAM to get 10%* Discount.
Order Nowlogo
(5/5)

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.

 

 

(5/5)
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

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Um e HaniScience

839 Answers

Hire Me
expert
Muhammad Ali HaiderFinance

730 Answers

Hire Me
expert
Husnain SaeedComputer science

818 Answers

Hire Me
expert
Atharva PatilComputer science

915 Answers

Hire Me

Get Free Quote!

427 Experts Online