Homework: Interpreting and Building Entity-Relationship Diagram (ERD)
Part 1:
For this part of the homework, you will use the "AdventureWorks 2014 OLTP Database," located in the Course Materials, and use the schema. Follow the tree/chain to answer the questions below in a Microsoft Word document.
o 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?
o 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.
o 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 homework, you will continue to assume you work at Adventure Works Cycles company. In the Topic 1 homework, 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.
o Create a simple Entity-Relationship Diagram ERD (using Draw.io or another similar application as approved by instructor) demonstrating how your new table will connect to the "HumanResources.Employee" table on the diagram. Since this is a new table, add new fields to create the proper relationships as you see fit.
o In a one to two paragraph Word document, explain how these fields relate to the rest of the database content.
o Compile the ERD file and Word document into a .zip file and submit to your instructor.
Format your homework according to the following formatting requirements:
o The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
o The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
o Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.