Re: Database Normalization

From: <ryan_oracle_at_cox.net>
Date: Mon, 03 Nov 2003 11:04:33 -0800
Message-ID: <F001.005D576D.20031103110433@fatcity.com>

ive seen tom kyte say the same thing. normalize unless its bad for design and/or hurts performance.

which is similiar to normalize until its inconvenient.

you could have some real fun and try to explan the boyce-codd normal form from an academic text book :)
>
> From: Jared.Still_at_radisys.com
> Date: 2003/11/03 Mon PM 01:34:26 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Database Normalization
>
> List,
>
> Doing some reading on Normalization today. We actually have the
> opportunity
> to create a database and app, and it's been so long since I've done this
> on a real
> project, a refresher was in order.
>
> I have the annoying habit of knowing what to do with normalization, based
> on past
> education and experience, but having difficulty explaining it to others.
> This is the kind
> of thing that makes Cary Millsap nuts. ( read the book if you don't know
> why )
>
> Mladen would no doubt find this very simple.
>
> Anyway, in the course of finding some recent web pages on this, one of the
> better
> was at a SQL server magazine site:
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887&pg=1
>
> The reason for writing however, was to show you the worst one so far:
> www.tinyurl/th7i
>
> Basically, 'normalize unless it's inconvenient'.
>
> Jared
>
>

List,

Doing some reading on Normalization today.  We actually have the opportunity
to create a database and app, and it's been so long since I've done this on a real
project, a refresher was in order.

I have the annoying habit of knowing what to do with normalization, based on past
education and experience, but having difficulty explaining it to others. This is the kind
of thing that makes Cary Millsap nuts. ( read the book if you don't know why )

Mladen would no doubt find this very simple.

Anyway, in the course of finding some recent web pages on this, one of the better
was at a SQL server magazine site:  http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4887&pg=1

The reason for writing however, was to show you the worst one so far:  www.tinyurl/th7i

Basically, 'normalize unless it's inconvenient'.

Jared

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <ryan_oracle_at_cox.net
  INET: ryan_oracle_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Nov 03 2003 - 13:04:33 CST