Question
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
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