Consider the following table:
A. Write SQL statements to display the values of any rows that violate these functional dependencies
B. If no data violate these functional dependencies, can we assume that they are valid? Why or why not?
C. Assume that these functional dependencies are true and that the data have been corrected, as necessary, to reflect them. Write all SQL statements necessary to redesign this table into a set of tables in BCNF and 4NF. Assume that the table has data values that must be appropriately transformed to the new design.