Question: In this module assignment, you will examine a scenario involving a hypothetical financial that is building a new database to support their trading operations. Your

In this module assignment, you will examine a scenario involving a hypothetical financial that is building a new database to support their trading operations. Your job is to troubleshoot that design by creating an entity relationship diagram that effectively addresses their needs, Arrows in the design should go from the table where the primary key is defined to the table where the key is used as a foreign key. In the amazon fresh ERD, product_id is defined in the product table, and is used in the sales table. So the direction of the arrow is from the product table to the sales table. The same product_id can be referenced many times in the sales table, so this is a one to many relationship. In the iTunes ERD, note that the Employee table has an arrow going from the employee IDcolumn to the reports to column. This is because the employee ID column contains the primary key of the employee in a row of this table and the reports to column contains the employeeID of that employee's supervisor. When many employees have the same manager, they will have identical values in the reports to column,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!