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.
1.
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
Grading Rubrics
Task Points Description
0 10 Business narrative includes enough
information to build a data model
1 30 ERD and DD that are a representation of the
business narrative and are in agreement with
each other
2 30 Successful creation of tables and constraints
as specified by ERD and DD with adequate
data inserted to demonstrate entity and
referential integrity
3 50 Successful update and meaningful reports
generated by queries
Total 120 A quality project will meet or exceed all of the
above requirements