Essay MIS 605 Topic 2 Assignment GCU
MIS 605 Topic 2 Assignment GCU
MIS 605 Topic 2 Interpreting and Building OpenOffice Draw Documents
The purpose of this assignment is to analyze the structure of a relational database and demonstrate the ability to correctly document and explain additions to the structure of a relational database.
Part 1:
For this part of the assignment, you will use the “AdventureWorks 2014 OLTP Schema.” Open the schema and follow the tree/chain to answer the questions below in a Word document.
- How does the Sales.SalesTerritory table relate to the Person.StateProvince table? Which table holds the Primary and the Foreign Key? On what field do they join together?
- If you wanted to know the Planned Cost of a Product, what route would you take to the data? Identify the tables and fields used to join on each.
- Imagine a bonus was paid to an employee using a different currency. Identify the fields you would need so you could access the information. List all the tables involved and the fields used to join.
Part 2:
For this part of the assignment, you will continue to assume you work at Adventure Works Cycles company. In the Topic 1 assignment, you made a request to add a field to the company database. That request has been approved, and now the database diagram needs to be accurately updated.
Create a simple OpenOffice Draw document demonstrating how your new table will connect to the Human Resources.Person table on the diagram. Since this is a new table, add new fields to create the proper relationships as you see fit.
In a one or two paragraph Word document, explain how these fields relate to the rest of the database content.
Compile the OpenOffice Draw file and Word document into a .zip file and submit to your instructor.
APA style is not required, but solid academic writing is expected.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are not required to submit this assignment to LopesWrite.
Guaranteed A+Stop Stressing. Your Academic Success is Guaranteed.
Domyassignment is your direct route to higher grades. Thousands of students trust our PhD-level experts to deliver 100% original, custom-written papers—from tough essays to massive dissertations.
