Normalisation - not understood

[liamm]

Hi,
could any of you guys recommend any good literature or sites that may explain normalisation in a better way than I've been told so far. I am really not grasping normalisation at the moment.
Cheers

Liam If you can help, GREAT
If I can help, EVEN BETTER

 

[tdatgod]

The Objective of Normalization

The intent of normalizing a relational database can be reduced to one simple aphorism:

One Fact In One Place.

By decomposing your relations into Third Normal Form, you can eliminate the majority of update anomalies that can
occur when data is stored in unnormalized tables.

Decomposition is attained through a series of projections of a relational schema into a set of normalized relations that optimize the concision of attributes.



I got this from Teradata RDBMS Database Design -- Chapter 5. You can get a copy at

http://www.info.ncr.com/dload.cfm?itemid=011900001

This book is not intended for a Novice but look through it and see if there is anything you can use.

 

[FEDSEC]

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
ISBN: 0201694719

Absolutely the best!

 

[vpshriyan]

Hi Liam,

Try these URLs, it may be useful.

http://www.cs.ust.hk/~cchui/space/db-normalization.doc

http://www.pcwebopedia.com/TERM/n/normalization.html

http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci212669,00.html

Regards,
Shriyan