Question: You have been assigned to develop a data model for a database that will allow Amazon to analyze the ordering habits of their customers as
You have been assigned to develop a data model for a database that will allow Amazon to analyze the ordering habits of their customers as well as provide information to their partners who are providing the products being sold about the types of customers who are purchasing their products. More detailed information on the entities, attributes, identifiers and relationships for the data model is provided below in the Entity-Relationship diagram format.

Entity Relationship Diagram Maximum cardinality-maximum number of entities in a relationship- e.g 1:1, 1:N, N:M- designated by crow's feet Adviser Department DeptName Admin Phone Email Student AdviserName Phone StudentNumber StudentName HW1 Campu:Address EmailAddress HW2 MidTernm Minimum cardinality-minimum number of entities in a relationship. Small oval means entity is optional; relationship need not have entity of that type. Vertical bar means at least one entity required. Entity Relationship Diagram Maximum cardinality-maximum number of entities in a relationship- e.g 1:1, 1:N, N:M- designated by crow's feet Adviser Department DeptName Admin Phone Email Student AdviserName Phone StudentNumber StudentName HW1 Campu:Address EmailAddress HW2 MidTernm Minimum cardinality-minimum number of entities in a relationship. Small oval means entity is optional; relationship need not have entity of that type. Vertical bar means at least one entity required
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
