Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Normalization

RE: Database Normalization

From: <Jared.Still_at_radisys.com>
Date: Mon, 03 Nov 2003 13:49:24 -0800
Message-ID: <F001.005D5796.20031103134924@fatcity.com>


More than enough. :)

DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> Sent by: ml-errors_at_fatcity.com
 11/03/2003 12:49 PM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: Database Normalization


Jared - Sounds fine. Do you feel you received the information you needed?

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, November 03, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L

Oh, I have *tons* of data modeling books/articles.

Just needed a quick refresher for the purpose of offering explanations.

Jared

                 DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> 
Sent by: ml-errors_at_fatcity.com

 11/03/2003 11:14 AM
 Please respond to ORACLE-L  

        To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

        cc: 
        Subject:        RE: Database Normalization



Jared - The book that has helped me the most is "The Data Modeling Handbook"
by Reingruber and Gregory. Their approach is to develop a best practice for
each modeling situation.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, November 03, 2003 12:34 PM To: Multiple recipients of list ORACLE-L

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: DENNIS WILLIAMS
 INET: DWILLIAMS_at_LIFETOUCH.COM

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
  INET: Jared.Still_at_radisys.com

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 - 15:49:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US