Furniture products are composed of components

Reference no: EM13686113

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.

Reference no: EM13686113

Questions Cloud

Identify the levels in the file hierarchy : Identify the levels in the file hierarchy and identify the order in which the directories need to be created and identify the commands used for creating the file hierarchy.

Since economists do not favour trade restrictions : Since economists do not favour trade restrictions, and this is a course in Managerial Economics, make the case as an economist against trade restrictions for Infant Industries. Are there any arguments for trade restrictions that most economists would..

Fiscal policy problem : "Fiscal Policy" Please respond to the following: Decide what fiscal policy measure has a more direct impact to the economy, an increase in government spending or an equal decrease in taxes if customer confidence is lower than the previous month.

Why is the use of system development methodologies : Why is the use of system development methodologies

Furniture products are composed of components : Furniture products are composed of components

Aggregate demand and supply : "Aggregate Demand and Supply" Please respond to the following: You have been hired as a consultant by your mayor to evaluate the increase in aggregate demand in the city where you live.

Classical ethical theories of utilitarianism : Classical ethical theories of utilitarianism

Government encouragement to include ethanol in gasoline : Which of the following commodities have been most directly influenced by government encouragement to include ethanol in gasoline?

Economic activity on both a global and domestic scale : With regards to the changes within the economic structure, how do politics and government regulation factor into the changes we see to economic activity on both a global and domestic scale? What actions have either helped or hindered our progress?

User Account

All Pages