Eliminate the transitive dependency in this relation

Assignment Help Basic Computer Science

Reference no: EM13308069

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.

Reference no: EM13308069

Questions Cloud

Write a sequence of statements that creates a new file : There are two text files, whose names are given by two String variables , file1 and file2. These text files have the same number of lines. Write a sequence of statements that creates a new file whose name consists concatenating the names of the tw..

How should joe respond to bill''s invitation : How should Joe respond to Bill's invitation?

Explain how a set of points maximizes the minimum angle : Prove that the smallest angle of any triangulation of a convex polygon whose vertices lie on a circle is the same. This implies that any completion of the Delaunay triangulation of a set of points maximizes the minimum angle.

Calculate the increase in the internal energy of the neon : Suppose a tank contains 774 m3 of neon (Ne) at an absolute pressure of 1.01Ã-105 Pa. What is the increase in the internal energy of the neon

Eliminate the transitive dependency in this relation : 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.

What will be its approximate speed in rpm : An AC inductor motor is rated at 1750 rpm with a line frequency of 60hz. If the motor is operated on a 50 hz line, what will be its approximate speed in rpm.

What is the average force exerted by the water on the diver : A 50-kg diver steps off a 10-meter high platform at the local pool. She comes to rest 3.0 meters below the surface of the water

Describe o algorithm that computes from e list of polygon : Let E be an unsorted set of n segments that are the edges of a convex polygon. Describe an O(nlogn) algorithm that computes from E a list containing all vertices of the polygon, sorted in clockwise order.

Discuss strategic use of knowledge : Kodak is the example of a company that went from innovator with valuable knowledge assets to filing bankruptcy in February 2012. Retrieve a newspaper article, a journal article, or even a stockholder report about Kodak at some point in history and di..

User Account

All Pages