304 North Cardinal St.
Dorchester Center, MA 02124
For this hands-on assignment, you will be working on several real-world datasets available from the Chicago Data Portal. You will be asked questions that will help you understand the data just like a data engineer would. You will be assessed both on the correctness of your SQL queries and results.
You will write SQL code to create a view that limits the data available to a user, create a stored procedure that users can run to update Leader Icons in the table, and then enclose that update code in a transaction to ensure that if an error occurs, your data remains in a consistent state.
Follow the instructions in the assignment to complete all the problems. Then share the Queries and Results with your peers for reviewing.
There is a total of 20 points available for this project. The breakdown is as follows:
Points for each problem will be awarded as follows:
You must submit a screenshot (JPEG) showing your solution to each of the problems. The screenshot must clearly show the SQL query and results for the query. The screenshots will be uploaded in the following sections.
Here is an example of a submission clearly showing both the SQL query and its results/output, when executed from the Db2 console.
I hope this Peer-graded Assignment: Final Assignment Solution would be useful for you to learn something new from this Course. If it helped you then don’t forget to bookmark our site for more Quiz Answers.
This course is intended for audiences of all experiences who are interested in learning about new skills in a business context; there are no prerequisite courses.
More Peer-graded Assignment Solutions >>