A. Does this relation contain a transitive dependency? If so, what is it? B. Redesign the relation to eliminate modification anomalies. C. Using these data, state assumptions about functional...

A. Does this relation contain a transitive dependency? If so, what is it?

B. Redesign the relation to eliminate modification anomalies.

C. Using these data, state assumptions about functional dependencies among the columns of data. Justify your assumptions on the basis of these sample data and also on the basis of what you know about retail sales.

D. Given your assumptions in part A, comment on the appropriateness of the following designs: