Home Work $2$

Draw an Entity$-$Relationship Diagram for the description below.

Your company sells Products to Customers. A customer can order many products. A

product can be sold to many customers. An Agent is responsible for many SalesOrders. Each

SalesOrder has one agent who is responsible for it$.$ An agent reports to one Manager. A

Manager manages many agents.

The following entities are identified and described with their attributes and primary

keys $($underlined$).$ Relationships between the entities are described using cardinalities.

Please use the entities and relationships described below to create the ER diagram.

Please refer to the example given in ERD$\_$Example$\_$Employee$\_$Dept$\_$Project.pdf

Entities

Customer $($Custld$,$ custName, email$)$

Product $($ProductName$,$ unitCost$)$

SalesOrder $($OrderNe$,$Custld,ProdDate,OrderDate,quantity$)$: Since the relationship between

a customer and a product is a many$-$to$-$many relationship, a Sales Order entity is created

for each order from a customer to a product.

Agent $($AgentName$,$ email$)$

Manager $($ManagerNo$,$managerName,commission$)$

Relationships

a$)$ Relationship between Product and SalesOrder is one to many $($one on Product

side and many on SalesOrder side$).$

b$)$ Relationship between Customer and SalesOrder is

$($one on

Customer side and many on SalesOrder side$).$

c$)$ Relationship between Agent and SalesOrder is

$($one on Agent side

and many on SalesOrder side$).$

d$)$ Relationship between Manager and Agent is one to many $($one on Manager side

and many on Agent side$).$