| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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). Received on Mon Nov 03 2003 - 13:14:26 CST
 |
 |