Time:
Scotland: Wed, 12:08 pm
Rhode Island: Wed, 7:08 am
Florida: Wed, 7:08 am
New Mexico: Wed, 5:08 am
California: Wed, 4:08 am

Click here to visit Livelife365.com

Click here to visit nmdarts.com



Buy this Ad Space.

180px wide.

Please get in touch with KH@ if you are interested and make an offer.

CLICK HERE TO GET AUCTION BAR NOW
US$10 per year - Save $100s!
The Fabulously Unfair
WebX Auction Bar. For Ebay etc.
Ro-Sham-Bo the opposition. Laugh like Eric Cartman when you win! CLICK HERE NOW!

More information and sign-up.

WebXpertz Hosting.
Custom fit from $5pm. PHP/MySQL
You'll save money, we'll save money. Seems fair to me. Interested? If so Please PM me here and tell me what you need. Thanks!


Please click here for more information

PDA

For continued disscussion on this topic : Data Normalisation

davemcd576
05-15-2004, 05:57 PM
Hi there, I was wondering if anyone could me help with some normalisation.
I understand how to get my data set into 1NF but I don't understand how to get to 2NF and 3NF.

My attributes are from a Delivery Fault Sheet.


UNF
Fault Sheet No
Date
Receiving Bay

Delivery Note No
Part Ref
Quantity Faulty
Fault Description
Fault Code
Checker's Name
Despatch Depot ID
Quarantine Location

1NF
Fault Sheet No
Date
Receiving Bay

FaultSheetNo
Delivery Note No
Part Ref
Quantity Faulty
Fault Description
Fault Code
Checker's Name
Despatch Depot ID
Quarantine Location

If anyone can give me any tips on how to get to 2NF and 3NF it would be much appreciated. Cheers