Exercise #1 — Assume that, at Fitzgerald 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), V

Exercise #1 — Assume that, at Fitzgerald 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 relations. Exercise #2 — Transfer the E-R diagram illustrated (attached) into a set of 3NF relations. Make up a primary key and one ore more non-keys for each entity.

 

Looking for a Similar Assignment? Let us take care of your classwork while you enjoy your free time! All papers are written from scratch and are 100% Original. Try us today! Use Code SAVE15 for 15% discount