a)Given the following conceptual representation:a)Transform the diagram into UML notation

.b)Based on the participation of Customer and Ordering Buys, what can you conclude?

c)Base on the cardinality of Supplies, what can you conclude?

d)Mention one alternate key for Supplier.

e)What is unit Costin this diagram? Why is it needed? Provide as many details as possible.

f)Convert the E-R diagram into tables. You can draw tables or provide the Relational Schema

g)What do you need to modify to specify that every item must supplied by a single provider (Supplier)?

h)How would you include employees in this diagram? Provide a clear explanation and illustrate your answer with an E-R extract

date totalAmount (firstName street lastName city orderNo state tax zip cust Name custAdd deliver To Address creditLimit Order zip custid M (street state food city Buys M Customer deliver To Phone areaCode Phone Contains Quantity number areaCode number N unitCost reorderPoint M N Supplier Supplies Item qtyOnHand supplier No contact Name Item No Item Name unit Price supAdd supName (street country Phone city Zip/ postalCode state countryCode areaCode number date totalAmount (firstName street lastName city orderNo state tax zip cust Name custAdd deliver To Address creditLimit Order zip custid M (street state food city Buys M Customer deliver To Phone areaCode Phone Contains Quantity number areaCode number N unitCost reorderPoint M N Supplier Supplies Item qtyOnHand supplier No contact Name Item No Item Name unit Price supAdd supName (street country Phone city Zip/ postalCode state countryCode areaCode number