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.

You have been assigned to develop a data model for a database

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

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!