Question: Problem 4: Consider a MAIL ORDER database in which employees take orders for parts from customers. The data requirements are summarized as follows: The mail

Problem 4: 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 each identified by a unique employee number, first and last name and Zip Code * Each customer of the company is identified by a unique customer number, * Each part sold by the company is identified by a unique part number, a Each order placed by s customer is taken by an employee and is given a first and last name and Zip Code. part name, price and quantity in stock. unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded Draw an Entity- Relationship diagram for the mail-order database and build the design
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
