Results 1 to 2 of 2

Thread: 3nf Help!

  1. 03-02-2007, 05:14 PM #1
    kristen88
    kristen88 is offline Registered User
    Join Date
    Mar 2007
    Posts
    3

    3nf Help!

    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))
    Reply With Quote Reply With Quote
  2. 03-05-2007, 10:06 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Class- Class#, ClassName
    Warehouse-Warehouse#, location,
    Part - PartNum, Description, OnHand, Class#, Warehouse#, Price
    Order - OrderNum, OrderDate, CustomerNum, RepNum, QuotedPrice,NumOrdered
    Customer - CustomerNum, LastName, FirstName
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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