Consider a MAIL_ORDER database in which employees take orders for parts from customers. The data requirements are summarized as follows: o The mail order company has employees, each identified by a unique employee number, first and last name, and Zip Code. o Each customer of the company is identified by a unique customer num, first and last name, and Zip Code. o Each part is identified by a unique part number, a part name, price, and quantity. o 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.
Consider a MAIL_ORDER
for parts from customers. The data requirements are summarized as
follows:
o The mail order company has employees, each identified by a
unique employee number, first and last name, and Zip Code. o Each customer of the company is identified by a unique
customer num, first and last name, and Zip Code. o Each part is identified by a unique part number, a part name,
price, and quantity.
o 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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images