For this part of the assignment, 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.
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 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.
In a one to two paragraph Word document, explain how these fields relate to the rest of the database content.
Compile the ERD file and Word document into a .zip file and submit to your instructor.