Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Normalization
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