sign an Entity-Relationship diagram for the below environment. determine 1-Total participation. 2-Partial participation Consider a MAIL_ORDER database in which employe
Design an Entity-Relationship diagram for the below environment.
determine
1-Total participation.
2-Partial participation
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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
