Assume that at Pine Valley Furniture products are composed of components, products are assigned to salespersons, and components are produced by vendors. Also assume that in the relation PRODUCT (Prodname, Salesperson, Compname, Vendor), Vendor is functionally dependent on Compname and Compname is functionally dependent on Prodname. Eliminate the transitive dependency in this relation and form 3NF (third normal form) relations.
~ PRODUCT has fields Prodname(Primary Key), Salesperson and Compname. Salesperson and Compname are functionally dependent Prodname.
VENDOR has fields Compname(Primary Key) and Vendor. Vendor is functionally dependent on Compname.