-
Functional Dependencies
Could anyone tell me what the functional dependencies would be for this table?
Part (PartNum, Description, OnHand, Class, Warehouse, Price, (OrderNum, OrderDate, CustomerNum, CustomerName, RepNum, LastName, FirstName, NumOrdered, QuotedPrice))
Thank you for any help.
-
Here's a guess; I just did this quickly so I would get it checked:
Order(OrderNum, OrderDate, CustomerNum, RepNum,Line)
Part (PartNum, Description)
Line(Line,PartNum, OnHand, Class, Warehouse, Price, NumOrdered)
Customer(CustomerNum, CustomerName)
Rep(RepNum, LastName, FirstName)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|