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.

Answer rating: 100% (QA)

We assume that the relation is already in 2NF and elimination of the transitive dependen... View the full answer