MIS 605 Topic 2 Assignment GCU

  • Description
  • Size Guide
  • Reviews (0)

Description

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.

  1. 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?
  2. 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.
  3. 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.

 

 

Course Tutor helps in providing the best essay writing service. If you need 100% original papers for MIS 605 Topic 2 Assignment GCU, then contact us through call or live chat.

MIS 605 Topic 2 Assignment GCU

Best MIS 605 Topic 2 Assignment GCU

MIS 605 Topic 2 Assignment GCU

ACCT 553 DeVryBIAM 500 DeVryCIS 500 STRCIS 558 STRENG 105 GCUFIN 390 DeVryFIN 504 GCUHCA 545 GCUHCA 699 GCUHLT 306 GCUHLT 362 GCUHLT 555 GCUHLT 610 GCUHLT 665 GCUHOSP 594 DeVryHRM 600 DeVryMAT 144 GCUMGMT 600MGT 599 STRMGT 655 GCUMKT 373 GCUPSY 362 GCUPSY 565 GCUPSY 575 GCUPSY 665 GCUSOC 102 GCUSOC 320 GCUSOC 372 GCUSOC 412 GCUNSG 6440 SUHIM 515 GCUNSG 4029 SUHIM 615 GCUNSG 3029 SUNSG 4055 SUNSG 6630 SUNSG 6005 SUCRMJ 310PSY 510 GCUCRMJ 300 DevryCRMJ 425SPD 200 GCU, HLT 490 GCU ,ECH 340 GCU , ECH 440 GCU , ECH 355 GCU ,ECH 350 GCU ,LDR 461 GCU ,ECH 425 GCU ,REL 212 STR ,SCI 115 STR ,CIS 505 STR ,JUS 652 GCUMGT 640 GCUCIS 527 STRSOC 436 GCU,ACC 502 GCUFIN 504 GCU , MATH 260 DeVry ,ETHC 445 DeVry ,ECET 220 DeVry , CARD 405 DeVryNETW 203 DeVryNETW 205 DeVryECET 365 DeVry ,MATH 270 DeVry ,PHYS 310 DeVry, BIB 106 GCU ,CIS 512 STR ,SYM 506 GCU ,ECN 601 GCU  ,BIAM 570 DeVryPSY 402 GCU , SOC 480 GCU , HUM 112 STR , PHI 210 STR,  ACC 667 GCU,  ACC 622 GCU,  ACC 623 GCU,  ENTR 510 DeVryDNP 840 GCU , BIO 550 GCU , HRM 420 DeVry , ACC 690 GCU  , HCA 807 GCU , ACC 650 GCU , REET 420 DeVry , MIS 605 GCU

 

 

size chest(in.) waist(in.) hips(in.)
XS 34-36 27-29 34.5-36.5
S 36-38 29-31 36.5-38.5
M 38-40 31-33 38.5-40.5
L 40-42 33-36 40.5-43.5
XL 42-45 36-40 43.5-47.5
XXL 45-48 40-44 47.5-51.5

Reviews

There are no reviews yet.


Only logged in customers who have purchased this product may leave a review.