Answer Happy

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.