The following is about a chain of stores selling a few products supplied by different companies.

SupplyChain (Store#, StoreName, StoreAddress, Product#, ProductName, sellingPrice, VendorName,VendorAddress, SupplyPrice)

• A store has one name and address.
• A product has a unique product name.
• Different stores sell the same product at a different price.
• Each product is supplied by only one vendor at a specific SupplyPrice.
• Each Vendor has one address.

Assume the PK of SupplyChain is {Store#+Product#}.

(1) Identify FDs (only direct, non-trivial and non-redundant ones). For unstated business rules, use your common sense and assumptions that are not contradictory to the stated assumptions.

(2) Check each FD against 2NF and 3NF

(3) What is the highest normal form of the original table

(4) Decompose into a 3NF schema

(5) Identify PKs and FKs. Indicate which FK references which tables PK.