CiS 336 STUDy Learn Do Live /cis336study.com CiS 336 STUDy Learn Do Live /cis336study.com | Page 38
1. You will demonstrate an update that includes two tables and uses
a subquery. Make sure to prove that your update executed correctly by
showing data in the tables before and after the update.
2. You will also develop at least four meaningful reports. One must
include a join, one must use a subquery, and one must use an
aggregate function. You need to describe the business requirement of
the update and each report. Note that numeric PK values are not often
meaningful to a person looking at the report. You will create a script
file that has each of the queries called yourname_task3.txt. You will
also document the results of this task in a Word document called
yourname_reports.docx to show the result of each query. For the
update and each report,
· describe the update and report requirement;
· show the query; and
· show the result of the query.
Include a final section for Conclusions and Lessons Learned
regarding the project.Note that your deliverables each week include
any revisions to a previous task.Submit your Task 3 deliv