Draft an Entity Relationship Diagram (ERD) for the following: The management of TAL Distributors, a wholesaler of finely crafted wooden toys, games, and puzzles, has determined that the company’s recent growth no longer makes it feasible to maintain customer, order, and inventory data using its manual systems. With the data stored in a database, management will be able to ensure that the data is up to date and more accurate than in the current manual systems. In addition, managers will be able to obtain answers to their questions concerning the data in the database easily and quickly, with the option of producing a variety of useful reports.
Management has determined that TAL Distributors must maintain the following information about its Reps (sales representatives), Customers, and Items in the new database.
-Each sales representative is identified by a unique Rep_Num. Other relevant information includes Rep_Name, Address, City, State, Zip, and Rate (the commission rate).
-Each customer is identified by a unique Customer_Num, Name, Address, City, State, Zip, Balance (current account balance), and Credit_Limit.
-Each customer is assigned to one and only one sales representative. Every sales representative is responsible for zero or multiple customers.
-Each item in Items (inventory) has a unique Item_Num. Items should also include Description, Quantity_On_Hand, Category, Warehouse, and Unit_Price for each item in inventory.
-TAL Distributors tracks the Order_Numer (identifier) and Order_Date of every order. Each customer can place zero or multiple orders. Every order is associated with one and only customer.
-Every order will include one or multiple items. Every item might be involved in zero or multiple orders. When an item is included in an order, TAL Distributors needs to track the Quantity_Ordered and the Quoted_Price.