Product ID Foreign Key) PrimaryKey Name CD Title Address Price Phone Number Number Available Saary ransaction Primary Key Employee ID Foreign Key) Hire Date Product ID Foreign Key Time of Purchase Books Transaction Total Product ID Primary Ke litle Author Price Number Available

  1. Discuss whether the tables above have satisfied 1NF, 2NF, and3NF. Explain why or why not.
  2. What changes should be made if the tables do not meet therequirement of the 3NF?

Product ID Foreign Key) PrimaryKey Name CD Title Address Price Phone Number Number Available Saary ransaction Primary Key Employee ID Foreign Key) Hire Date Product ID Foreign Key Time of Purchase Books Transaction Total Product ID Primary Ke litle Author Price Number Available Show transcribed image text