· Your Task 1 DD ( with any revisions )
· Your Task 2 script file to create and populate tables ( yourname _ task2 . txt )
· A Word document showing all tables and data ( yourname _ tables . docx )
Task 3
Your final task is to use your tables for an update and for reports . There are two requirements .
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