Re: Advanced SQL

From: David Cressey <cressey73_at_verizon.net>
Date: Fri, 07 Sep 2007 05:13:14 GMT
Message-ID: <K55Ei.12077$Ov2.1390_at_trndny06>


"David Portas" <REMOVE_BEFORE_REPLYING_dportas_at_acm.org> wrote in message news:pZSdnfih_oRy5H3bRVnyigA_at_giganews.com...

> 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"
>

I'm not entirely comfortable with it myself, and I had found some of the same things you quoted. I still recommend it. I'm looking for something that's better. when I find it, I'll recommend that. Received on Fri Sep 07 2007 - 07:13:14 CEST

Original text of this message