Consider an Auto Parts company in which employees take orders for parts from customers. The data

requirements are summarized as follows:

The company has employees identified by a unique employee number, their first and last names,

email addresses, and phone number.

The customers of the company are identified by a unique customer number, their first and last

names, email addresses, and phone number.

The parts being sold by the company are identified by a unique part number, a part name, their price,

and quantity in stock.

Orders placed by customers are taken by employees and are given a unique order number. Each

order may contain certain quantities of one or more parts and their received date as well as a

shipped date is recorded.

Design an Entity$-$Relationship diagram for the database using SSMS$.$