Example: A mail order database. It takes orders for parts from employees and for end customers. Use ERDPlus.com to create an ERD for the problem below. There is only on mail order company so you need not create an entity for that$($answer should include finalized ERD image $/$ photo$).$

Requirements:

The mail order company has employees, each identified by a unique employee number, and have a first and last name and zip code.

Each customer of the company is identified by a unique customer number, first and last name, and zip code. Each part sold by the company is identified by a unique part number, name, price, and quantity in stock.

Each order placed by a customer is taken by an employee and is given a unique order number.

Each order contains specified quantities of one or more parts.

Each order has a date of receipt, expected ship date, actual ship date, and total of the order.