Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft Visual Basic 2005 For Windows Mobile Web Office And Database Applications Comprehensive

Authors: Gary B. Shelly, Thomas J. Cashman, Corinne Hoisington

1st Edition

0619254823, 978-0619254827

More Books

Students also viewed these Databases questions