Find Us On: Facebook Twitter Rss Feed Blog
Need To Register? Sign Up Login

Premiere Products

stretch8302
stretch8302 


Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form. Part (PartNum, Description, OnHand, Class, Warehouse, Price, (OrderNum, OrderDate, CustomerNum, CustomerName, RepNum, LastName, FirstName, NumOrdered, QuotedPrice) ) Attachments
Tags Clarifications

Answers

Function Dependencies And 3NF

dickersonka
dickersonka 



Functional Dependencies:

PartNum -> Description, OnHand, Class, Warehouse, Price
OrderNum -> OrderDate, CustomerNum, RepNum, QuotedPrice, NumOrdered,...
Attachments
FunctionalDependencies&3NF.txt (1 K) Download Preview
QuotedPrice) ) Functional Dependencies: PartNum -> Description, OnHand, Class, Warehouse, Price OrderNum -> OrderDate, CustomerNum, RepNum, QuotedPrice, NumOrdered,

Screenshots
Purchase Answer