Your final task is to use your tables for an update and for reports.

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.

 

  • 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.

 

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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 deliverable as a zip file including the following.

Course Project TablesCompanySELECT *FROM CompanyApplianceParts Parts1224334551PartsSELECT *FROM PartsPartNo ApplianceParts Haier Whirlpool Frigidaire LGSamsung11rioefyesbattery cover25nilefnobattery cover33hooefgitbattery cover44rioefcallboxpio52rioefyesbattery scrnOrdersSELECT *
Background image of page 1
View

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.

  • 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 deliverable as a zip file including the following.

Course Project TablesCompanySELECT *FROM CompanyApplianceParts Parts1224334551PartsSELECT *FROM PartsPartNo ApplianceParts Haier Whirlpool Frigidaire LGSamsung11rioefyesbattery cover25nilefnobattery cover33hooefgitbattery cover44rioefcallboxpio52rioefyesbattery scrnOrdersSELECT *
Background image of page 1