work on this task, use the “Labs on Demand Assessment Environment…

work on this task, use the “Labs on Demand Assessment Environment and DVD Database” found in the Web Links section. In this environment, you will be able to write and test your PostgreSQL code and access the database to complete this task. 

 

Plan for and compose the sections of a real-world business report that can be created from the “Labs on Demand Assessment Environment and DVD Database” web link, and demonstrate the functionality of the supporting SQL code by doing the following:

 

A.  Summarize one real-world written business report that can be created from the DVD Dataset from the “Labs on Demand Assessment Environment and DVD Database” attachment. 

1.  Identify the specific fields that will be included in the detailed table and the summary table of the report.

2.  Describe the types of data fields used for the report.

3.  Identify at least two specific tables from the given dataset that will provide the data necessary for the detailed table section and the summary table section of the report.

4.  Identify at least one field in the detailed table section that will require a custom transformation with a user-defined function and explain why it should be transformed (e.g., you might translate a field with a value of N to No and Y to Yes).

5.  Explain the different business uses of the detailed table section and the summary table section of the report. 

6.  Explain how frequently your report should be refreshed to remain relevant to stakeholders.
 

B.  Provide original code for function(s) in text format that perform the transformation(s) you identified in part A4.
 

C.  Provide original SQL code in a text format that creates the detailed and summary tables to hold your report table sections.
 

D.  Provide an original SQL query in a text format that will extract the raw data needed for the detailed section of your report from the source database.
 

E.  Provide original SQL code in a text format that creates a trigger on the detailed table of the report that will continually update the summary table as data is added to the detailed table.
 

F.  Provide an original stored procedure in a text format that can be used to refresh the data in both the detailed table and summary table. The procedure should clear the contents of the detailed table and summary table and perform the raw data extraction from part D.

1.  Identify a relevant job scheduling tool that can be used to automate the stored procedure.
 

G.  Provide a Panopto video recording that includes the presenter and a vocalized demonstration of the functionality of the code used for the analysis.
 

Note: For instructions on how to access and use Panopto, use the “Panopto How-To Videos” web link provided below. To access Panopto’s website, navigate to the web link titled “Panopto Access,” and then choose to log in using the “WGU” option. If prompted, log in using your WGU student portal credentials, and then it will forward you to Panopto’s website.

 

To submit your recording, upload it to the Panopto drop box titled “Advanced Data Management D191 | D326 (Student Creators) [assignments].” Once the recording has been uploaded and processed in Panopto’s system, retrieve the URL of the recording from Panopto and copy and paste it into the Links option. Upload the remaining task requirements using the Attachments option.
 

H.  Acknowledge all utilized sources, including any sources of third-party code, using in-text citations and references. If no sources are used, clearly declare that no sources were used to support your submission.
 

I.  Demonstrate professional communication in the content and presentation of your submission.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Use the SaleCo ERD listed below and the provided SQL scripts to…

Use the SaleCo ERD listed below and the provided SQL scripts to construct its relational database and answer the following queries. Note: Purchases = LINE_PRICE * LINE_UNITS Note: Inventory value = P_QOH * P_PRICE   (2 pts) How many invoices are there?  (3 pts) List the invoice numbers and the

-draw an ER model clearly denoting maximum and minimum cardinality…

-draw an ER model clearly denoting maximum and minimum cardinality constraints.  -Write one-liner and four sentences for each diagram (statements that specify the minimum and maximum cardinality), and the number of tables needed. Post the Primary and foreign keys and any available attributes. -diagram must be complete in all respects

1. Compare and contrast the tuple relational calculus with domain…

1. Compare and contrast the tuple relational calculus with domain relational calculus. Specifically, discuss the distinction between tuple and domain variables.    2. Answer the following questions considering the Hotel schema I have attached below.a) πhotelName (Hotel ⋈ Hotel.hotelNo = Room.hotelNo (σprice > 50(Room)) ).b) Guest ⊐⊲ (σdateTo≥ ‘1-Jan-2007’ (Booking)). 

 most important steps in solving a math problem is to understand…

 most important steps in solving a math problem is to understand what the problem is asking you to do. Read the problem carefully and make sure you understand what is being asked. Look for keywords and phrases that indicate what operation(s) you need to perform to solve the problem. Identify

Database Model: KimTay The management of KimTay Pet Supplies (a…

Database Model: KimTay The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in Cody, Wyoming) has determined that the company’s recent growth no longer makes it feasible to maintain customer, invoice, and inventory data using its manual systems. In addition, KimTay Pet Supplies wants

MCQ: Which of the following is true of NoSQL databases? Group of…

MCQ: Which of the following is true of NoSQL databases? Group of answer choices   They are geared toward transaction consistency rather than performance.   They do not support distributed database architectures.   They do not support very large amounts of sparse data.   They are not based on the

7-1 Project Two: Analyzing Databases.  (Please provide Codio…

7-1 Project Two: Analyzing Databases.  (Please provide Codio Screenshots thanks)     Competency In this project, you will demonstrate your mastery of the following competency: Analyze the results of queries constructed to address data requirements Scenario The product manager of Quantigration has asked your data analytics team for a report