Database Help

An ITEM is supplied by one SUPPLIER; a SUPPLIER can supply multiple ITEMs. Some ITEMs are created by the store, and don't have a SUPPLIER.

A STORE sells many ITEMs. An ITEM could be sold at many STOREs.

A STORE can receive from multiple SUPPLIERs. Each SUPPLIER can provide for multiple STOREs.

A business owns several stores. The stores each get products from many suppliers to sell in their stores. Some stores don't sell all of the items, or use all of the suppliers.

List at least three attributes for each of the entity types below, and then indicate which would be a good entity identifying attribute(s) for each.

STORE

PRODUCT

SUPPLIER