Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Review the business rules for the inventory for a local mom-n-pop store. - Store must have one and only one Address location - Store must
Review the business rules for the inventory for a local mom-n-pop store. - Store must have one and only one Address location - Store must stock one or many Products - Each Product may be stocked in only one Store - Each Product must belong to one and only one Product Category - Each Product Category must have one or more Products - Each Product must be shipped by one and only one Shipper - Each Shipper may ship zero or more Products Example: The following diagram has two entities - Agent and Customer. Agent has 1:M relationship with Customer. Customer has M:1 relationship with Agent. Answer the following questions based on the above business rules and example - 1. Use the above business rules and draw an ER Diagram in ERDPlus.com diagram tool 2. Create the ER Diagram showing the Entities and Relationships only (no need - PKs, FKs) 3. Paste the PNG image of the ER Diagram, exported from ERDPlus, in the document below
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