Question: 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

 Consider a MAIL_ORDER database in which employees take orders for parts

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 num, first and last name, and Zip Code. - Each part is identified by a unique part number, a part name, price, and quantity. - 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 as well as an expected ship date. The actual ship date is also recorded. Design an Entity-Relationship diagram for the above environment. Make sure you show in your diagram the following: 1- The primary key for each entity. 2- Determine cardinality ratio and participation constraint of each relationship type

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!