Entity Relationship Diagram (ERD) Practice
Practice 1: Re-draw below ERD using Lucidchart.com’s Crow’s foot notation and based
on following business rules.
A salesperson may manage many other salespeople. A salesperson is managed by only
one salespeople. A salesperson can be an agent for many customers. A customer is
managed by one salespeople. A customer can place many orders. An order can be
placed by one customer. An order lists many inventory items. An inventory item may be
listed on many orders. An inventory item is assembled from many parts. A part may be
assembled into many inventory items. Many employees assemble an inventory item
from many parts. A supplier supplies many parts. A part may be supplied by many
suppliers.
