Re: Advanced SQL
Date: Thu, 6 Sep 2007 23:06:35 +0100
Message-ID: <pZSdnfih_oRy5H3bRVnyigA_at_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 PortasReceived on Fri Sep 07 2007 - 00:06:35 CEST