Vendor is functionally dependent on compname and compname


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.

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Vendor is functionally dependent on compname and compname
Reference No:- TGS0646755

Expected delivery within 24 Hours