multiple data types in normalized database

On Mon, 14 Feb 2005 11:47:03 -0600, "Tony Vrolyk" tvrolyk at mlhg dot
net wrote:

I
think I understand the basics and in msot cases my dbs have been normalized
to a large degree

A nitpick--normalization applies to tables, not to databases.

I wasn't
aware of the specific normalization types 1NF, 2NF and so on. I did a search
and found this article -
http://www.devshed.com/c/a/MySQL/An-...rmalization/1/ -

Assuming it is accuratly written than I am at least designing my dbs to
satisfy 3NF which I was happy to find out.

"The Three Normal Forms" is a dead giveaway. There are at least
seven, and I think Chris Date has recently written about another, but
I could be wrong about that.

There's a *lot* of misinformation about normalization and database
design on the web. I don't think you can do better than Date's
_Introduction to Database Systems_, and it's easy to do a lot worse.
You can probably find a used copy pretty cheap, but get the seventh
edition, at the very least.

--
Mike Sherrill
Information Management Systems