Normalisation and relationships.

[Joe Robinson]

Hi,

Can anyone recommend a book or website where I can get information about
normalisation and entity relationship analysis of databases. It is driving
me mad - can't understand how it works so I need something which explains it
in a very simple way!!

Joan

 

[Arvin Meyer]

Can anyone recommend a book or website where I can get information about
normalisation and entity relationship analysis of databases. It is driving
me mad - can't understand how it works so I need something which explains it
in a very simple way!!

Here's a free whitepaper to start:

http://support.microsoft.com/default.aspx?scid=kb;en-us;283878

There are also some very good books on the subject. Probably the best place
to start is: Michael J. Hernandez's book "Database Design for Mere Mortals"

http://www.amazon.com/exec/obidos/tg/detail/-/0201752840/qid=1066304400/sr=1
-1/ref=sr_1_1/002-5519028-8169644?v=glance&s=books

another great one for beginners (it's out of print but often still available
at Amazon) is "Designing Relational Database Systems" by Rebecca Riordan

http://www.amazon.com/exec/obidos/tg/detail/-/073560634X/qid=1066304472/sr=1
-5/ref=sr_1_5/002-5519028-8169644?v=glance&s=books

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Mike Painter]

Hi,

Can anyone recommend a book or website where I can get information about
normalisation and entity relationship analysis of databases. It is driving
me mad - can't understand how it works so I need something which explains it
in a very simple way!!

The help file has a bit of information.

 

[Albert D. Kallal]

Here is a few refs:

ACC2002: Database Normalization Basics
http://support.microsoft.com/?id=283878

Database Normalization Tips by Luke Chung
http://www.fmsinc.com/tpapers/genaccess/databasenorm.html

Data Normalization Fundamentals by Luke Chung
http://www.fmsinc.com/tpapers/datanorm/index.html

324613 - Support WebCast: Database Normalization Basics
http://support.microsoft.com/?id=324613

 

[Lin]

Letts - Database Design & Management using Access by Nick Dowling. £8.95..
It is easy to read and informative. I saw it on the shelf of my local
bookshop, but I sure you could find it browing an online bookstore.