$($a$)$ Draw a logical level ER diagram based on the following scenario. Indicate

clearly any assumptions that you make.

$(15$ Marks$)$

A salesperson can be an agent for many customers. A customer is managed by

one salesperson. 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.

b$)$ Convert this ERD into Relational Model.

$(15$ Marks$)$