CIS 336 TASK 3 AND ILAB WEEK 7

Online Essay Writing Service
Question
PLEASE NOTE THAT THESE ASSIGNMNETS MUST BE COMPLETED ONTIME AND IN IT’S COMPLETELY. PART 1 IS TASK ONE AND HAS TO BE COMPLETED SEPERTELY AND PART 2 IS THE ILAB AND INSTRUCTIONS ARE IN THE ATTACHMENTS
Task 3 (due at the end of Week 7)
Your final task is to use your tables for an update and for reports. There are two requirements.
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.
Task 0 proposal (with any revisions)
Your Task 1 ERD (with any revisions)
Your Task 1 DD (with any revisions)
Your Task 2 script file to create and populate tables (with any revisions)
A Word document showing all tables and data (with any revisions)
Your Task 3 script file with update and reports (yourname_task3.txt)
A Word file with results of Task 3 and lessons learned (yourname_reports.docx)
Attachments:
cis336lab7_studentanswersheet.docx
cis336lab7_instructions.docx
cis336_createomtables-2.docx
Answer
Computer Science homework help
This is property of essayprince.net. Log in to access Online Essay Writing Service today

Calculate your paper price
Pages (550 words)
Approximate price: -
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Open chat
1
Hello Good Friend
We are here at your service.
How can we help you today?

Order your essay today and save 16% with the discount code SUMMERFEST20