Results 1 to 2 of 2

Thread: Functional Dependencies

  1. #1
    Join Date
    Feb 2009
    Posts
    1

    Question 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.

  2. #2
    Join Date
    Feb 2009
    Posts
    3
    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
  •