Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, I need to create an ERD diagram using crow feet, help me out. The organization is a wholesale company that buys products from suppliers

Hi, I need to create an ERD diagram using crow feet, help me out.

The organization is a wholesale company that buys products from suppliers (manufacturers or importers) and sells them to customers. The company operates a number of depots which hold stocks of products and deliver orders to all customers in a geographical area assigned to them. The company has a number of Sales Representatives who take orders from customers. The new database must address the following requirements. 1. Manage the required and optional information of active and inactive Suppliers. 2. Manage the required and optional information of active and inactive Products. 3. Manage the required and optional information of active and inactive Sales Representatives. 4. Manage the required and optional information of the organizations Depots. 5. Manage the required and optional information of the organizations Geographical Areas. 6. Manage the required and optional information of active and inactive Customers. 7. Manage the required and optional information of Customers Orders 8. Manage the required and optional information of Customers Credit Status

The new structure needs to accommodate the following Business Rules:

1. Multiple Suppliers may supply the same Product. 2. Each Product is supplied by a Supplier to only one Depot and then moved on into stock at the other depots. 3. Each Geographical Area has only one Depot. 4. Each Sales Representative is assigned to all the Customers who are supplied from their assigned Depots. 5. Each customer is delivered to from only the Depot in the Geographical Area in which they are located. 6. Each Customer is located in one place only (i.e., in only one depot's area). 7. Customers place Orders which contains Order Lines (at least one), with each line ordering a different Product specifying the quantity of the Product to be supplied. (i.e., no two lines on the same order are for the same product) 8. Only the current prices of Products will be maintained (i.e., no price history is retained), however, the price at the time an order was placed needs to be recorded. 9. Each customer has a credit limit. Customer may not order more products if they have exceeded their limit

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

Build It For The Real World A Database Workbook

Authors: Wilson, Susan, Hoferek, Mary J.

1st Edition

0073197599, 9780073197593

Students also viewed these Databases questions

Question

4. Explain the characteristics of successful mentoring programs.

Answered: 1 week ago