Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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!
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 solutionStep 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