Results 1 to 2 of 2

Thread: convert to 3nf

  1. #1
    Join Date
    Mar 2007
    Posts
    3

    convert to 3nf

    i need help taking this table to third normal form.

    Part(PartNum, Description, OnHand, Class, Warehouse, Price,
    (OrderNum, OrderDate, CustomerNum, CustomerName, RepNum,
    LastName, FirstName, NumOrdered, QuotedPrice))

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    you need part, customer and order tables.

    since it looks like an assignment i am only giving you a hint, got a deal with your professor .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •