Consider a MAIL_ORDER database in which employees take orders for parts from customers. The data requirements are summarized as follows:

e mail order company has employees, each identi ed by a unique em- ployee number, rst and last name, and Zip Code.

Each customer of the company is identi ed by a unique customer number, rst and last name, and Zip Code.

Each part sold by the company is identi ed by a unique part number, a part 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 speci ed quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. e actual ship date is also recorded.

Design an entityrelationship diagram for the mail order database and build the design using a data modeling tool such as ERwin or Rational Rose.