Normaisation help

From: john <pc.hardwarespamblocker_at_ntlworld.com>
Date: Fri, 6 Dec 2002 19:51:57 -0000
Message-ID: <asqv44$tikk7$1_at_ID-164235.news.dfncis.de>



Sorry if i have posted in the wrong place but this looked a good place. I am having a hard time getting to grips with normalisation. Any websites i find are heavily sql based and not that easy to work out as they dont offer many examples.

I have the following examplewhich needs to be broken down from unnormalised to 3rd nf.

Can anybody show me the steps and stages i understand repeating fields and calculations should be removed, as they can me worked out.

Its a invoice example:
Invoice No
Date
Customer No
Customer Name
Customer Address
Vehicle Registration No
Vehicle Make
Year Of Manufacture
Fault Description (one long text field)
Information for each part replaced:

   Part No
   Description
   Cost
   Qty
Overall Labour Cost
Total Amount payable Received on Fri Dec 06 2002 - 20:51:57 CET

Original text of this message