Please create an ER diagram based on these entities (in bold) and their relations using crows foot notation. In databas

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

Please create an ER diagram based on these entities (in bold) and their relations using crows foot notation. In databas

Post by answerhappygod »

Please create an ER diagram based on these entities (in
bold) and their relations using crows foot notation. In
database design.
a. An Employee/SalesRep always creates one or
more Customer accounts,
b. A Customer account is always created by only
one Employee/SalesRep;
c. An Employee/SalesRep always takes one or more
Customer orders,
d. A customer Order is always taken by only one
SalesRep;
e. An Order is sometimes broken down into one or
more Shipment(s),
f. A Shipment is always related to one or more
Order(s);
j. A Customer can always have one or more
orders of Furniture delivered to his/her
delivery address;
k. A Truck is always assigned to only one
Driver,
l. Each Driver is always assigned only one
Truck;
m. An Employee/Operations Manager always plans one
or more daily deliveries,
n. Each daily delivery is always assigned by only one
Operations Manager;
o. Large Customer orders are always broken down
into delivery units called Shipment(s),
p. A Shipment is sometimes part of one larger
Customer order;
q. A Shipment has to always fit in only one
Truck,
r. A Truck will sometimes carry more than one
Shipment;
s. A small Order is always delivered as one
Shipment,
t. A Shipment is sometimes related to one or more
Order(s);
u. Daily Shipments are always assigned to one or
more available Trucks,
v. An available Truck is always assigned one or
more Shipments;
some extra info: operations manager, sales rep, and driver are
subtypes of Employees.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply