Wholesalers is a wholesale business organization that supplies a variety of products to its retail busines

customers $($some of the company's customers include retailers such as Target, Wal$-$Mart, etc.$)$

Wholesalers has asked you to design a small database segment with the following business rules and

requirements:

$$ When a Wholesalers customer purchases products, an invoice is prepared for the customer. Data

needs to be kept about invoice date along with selling price and quantity of each product sold. A

Wholesalers customer may receive one or more invoices, though each invoice is associated with a

single customer.

$$ Wholesalers also keeps necessary data about its customers and products.

Draw an ER diagram using MySQL Workbench software for the database segment described above.

The ER diagram should contain necessary entities, relationships between entities, and attributes of the

entities. Please make sure that every entity has a primary key. Foreign keys are added by MySQL

workbench automatically when you create relationships. Also, include the following attributes with

entities where they belong:

Product name; product base price; customer name; customer phone number; customer credit limit; date of

invoice; information about products being invoiced including product code, quantity sold $($i$.$e$.,$ how many

units of the product the customer bought$),$ and product's selling price per unit