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
Get step-by-step solutions from verified subject matter experts
