Re: 2nd and 3rd Normals

batonnet@zeta.org.au (Bryan Tonnet) wrote: >For 3rd normal, each non key column in the table (not primary or foreign) >has to be dependant on the primary key only. For example, if our order file >contained stock number, and stock description, then it could be said that >stock description is functionaly linked to the order number but also to the >stock number, and therefore the table in not 3rd normal. My way to see things is: in 2nd normal, you can have a column whose value is dependent on another non-key column, in 3rd form you cannot. Bye, Patrick --- Patrick Preuss http://home.t-online.de/home/patrick.preuss ppr@deckard.hb.north.de We are all working together to one end, some with knowledge and design, and others without knowing what they do. Marcus Aurelius