Re: Normaisation help

"john" <pc.hardwarespamblocker_at_ntlworld.com> wrote in message news: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
>
>

Hmm... a search at google on "primer on data normalization" seems to bring-up a few useful links. Ditto search on "data normalization invoice example".

HTH

--
Akmal B. Chaudhri
Zone Editor, Special Projects (Eclipse, Grid, Web Services)
IBM developerWorks - http://www.ibm.com/developerWorks/
WebDatabases ------- http://www.btinternet.com/~webdatabases/