Re: Advanced SQL

From: David Portas <REMOVE_BEFORE_REPLYING_dportas_at_acm.org>
Date: Thu, 6 Sep 2007 23:06:35 +0100
Message-ID: <pZSdnfih_oRy5H3bRVnyigA@giganews.com>

"David Cressey" <cressey73_at_verizon.net> wrote in message news:HBTDi.14699$tB2.1005_at_trndny05...
>
> There are two webistes I can recommend:
>
> http://www.utexas.edu/its-archive/windows/database/datamodeling/dm/overview.html
>
> For an overview to data modeling and database design.
>
> and
>
> http://www.databaseanswers.org/
>
> For about 200 free database designs, covering many common problems. You
> will want to revise the design to suit your own requirements.
>
>
>

Call me picky but I am not entirely comfortable with that U.Texas site, even though it's a commendable effort overall.

"The relational model represents data in the form of two-dimension tables"
"A relational table is a flat file ..."
"Primary and foreign keys are the most basic components on which relational 

theory is based."
"The definition of second normal form states that only tables with composite primary keys can be in 1NF but not in 2NF" "The third normal form requires that all columns in a relational table are dependent only upon the primary key"

http://www.utexas.edu/its/windows/database/datamodeling/rm/overview.html
http://www.utexas.edu/its/windows/database/datamodeling/rm/rm1.html
http://www.utexas.edu/its/windows/database/datamodeling/dm/keys.html
http://www.utexas.edu/its/windows/database/datamodeling/rm/rm7.html

-- 
David Portas

Received on Thu Sep 06 2007 - 17:06:35 CDT