Question: Does anyone know how to do ERDs? I am not sure I have done this correctly or the relationships. I am using Visio. Thanks! Customer

Does anyone know how to do ERDs? I am not sure I have done this correctly or the relationships. I am using Visio. Thanks!

Does anyone know how to do ERDs? I am not sure I

have done this correctly or the relationships. I am using Visio. Thanks!

Customer Table First Name Last Name Date of birth Gender Address City State ZipCode Phone Number email Product Table Product Number Product Name Description Department Category Dimensions Weight Sales Table Customer Name (or some type of customer identifier) Product Number or some type of product identifier) Quantity sold Price DateTime of sale MGMT 329: Database Management Shipping Method (Air or Ground) Shipping Company (UPS, Fedex, USPS, etc) Shippingrype Next day, 3 day, standard, etc) Project Task 3: Requirements For this task, you are to create an Entity Relationship Diagram CERD based on the requirements we have identified. You should determine relationships between the tables and identify the primary and foreign keys. Use the three tables provided above as your starting point for developing your ERD. You may need to add additional entities and attributes to your ERD solution. In addition, you should also consider the customer's billing information and shipping address in your ERD solution

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!