Question: using Er diagram Identify the Entities and Attributes and Draw the ER diagram. 1. Consider a mail order database in which employees take orders for

using Er diagramusing Er diagram Identify the Entities and Attributes and Draw the ER

Identify the Entities and Attributes and Draw the ER diagram. 1. 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 identified by a unique employee number, their first and last names, and a zip code where they are located Customers of the company are uniquely identified by a customer number. In addition, their first and last names and a zip code where they are located are recorded. . The parts being sold by the company are identified by a unique part number. In addition, a part name, their price, and quantity in stock are recorded Orders placed by customers are taken by employees and are given a unique order number. Each order may contain certain quantities of one or more parts and their received date as well as a shipped date is recorded

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!