Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Normaisation help

Normaisation help

From: john <pc.hardwarespamblocker_at_ntlworld.com>
Date: Fri, 6 Dec 2002 19:51:57 -0000
Message-ID: <asqv44$tikk7$1@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 - 13:51:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US