$******$ Points: $30$

$******$ Turn in a hard copy and submit a soft copy to the Blackboard. $******$

$******$ Hand$-$written Diagram is accepted if it is neat. Computerized format is preferred. $******$

Design by Entity Relationship modeling $($If you use an ER notation other than the one in our textbook, please attach a legend$)$

Consider a MAIL$\_$ORDER database in which employees take orders for parts from customers. The data requirements are summarized as follows:

The mail order company has employees$--$ employee number, name, date of hire, and zip code, identified by employee number

Each parts sold by the company is identified by a unique part number and has the following information: a part name, price and quantity on stock.

receipt as well as expected ship date. The actual ship date is also recorded.

Your tasks: $$

a$)$ Draw an ER Diagram for this situation. State any assumptions that you have made.

b$)$ Convert your design to relational schemas.