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 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
Get step-by-step solutions from verified subject matter experts
