Consider the universal relation schema INVENTORY (Store#, Item, Vendor, Date, Cost, Units, Manager, Price, Sale, Size, Color, Location) and the constraint set F {fd1, fd2, fd3, fd4, fd5, fd6, fd7} where:

a. Do the functional dependencies shown constitute a minimal cover of F? If not, do they derive a minimal cover?
b. Derive the candidate key(s) of URS using the synthesis approach.
c. Derive the candidate key(s) of URS by using the decomposition approach.

Transcribed Image Text:

f31: {item. Vendor) fd2: {Store#, Date) → (Manager, Sale) fd4: Manager-> Store# fd6: Item (Size, Color) Cost fd3: (Store#, Item, Date) fas: Cost → Price Units fd7: Vendor Location