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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started