Question: g)What do you need to modify to specify that every item must supplied by a single provider (Supplier)?(10marks) h How would you include employeesin this

g)What do you need to modify to specify that every item must supplied by a single provider (Supplier)?(10marks)
h How would you include employeesin this diagram? Provide a clear explanation and illustrate your answer with an E-R extract(15marks).
1. Given the following conceptual representation: order No date totalAmount tax firstName Street City lastName state zip custName custAdd creditLimit Order custid . deliver To Address zip street state city deliverTo Phone areaCode Buys M Customer Phone Contains Quantity number areaCode number N unitCost reorder Point M N Supplier Supplies Item qtyOnHand supplier No contactName Item No Item Name unitPrice supAdd supName street Zip/ country Phone city postal Code state countryCode areaCode number
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
