Question

(a) An organization purchases items from a number

of suppliers. Suppliers are identified by

SUP-ID. It keeps track of the number of each

item type purchased from each supplier. It also

keeps a record of supplier's addresses. Supplied

items are identified by ITEM-TYPE and have

description (DESC). There may be more than

one such address for each supplier and the price

charged by each supplier for each item type is

stored.

Identify the entities and relationships for this

organization and construct an E-R diagram. From

the E-R diagram, write the scripts for creating a schema​

Answer 1

Answer:

I doesn't know the answer I will try the best next time

Answer 2

Answer:

it is very tuff question

Explanation:we got this for our 10 th class exam in ssc board himachalpradesh thank you may god bless you aamen