| 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: Data Modeling
I would read some of C.J. Date's papers, or books from his "Relational
Database Writings" series. Also, there is a recent book called "Data
Modeling for Everyone" by Sharon Allen (Curlingstone Press) which is good.
Most importantly, understand the fundamental principles of relational theory as it pertains to relational databases. If you make an effort at this you'll be ahead of 90% of developers/DBAs in this area, in my opinion. I've heard "database experts" say that relational databases are called that because they "relate" one table to another. This is false. It is called "relational" because it is based on relational math, and because columns are grouped together into special relations called relational tables. We call them tables for short.
The important thing to note here is this: the relationship that matters most is the relationship among the columns of the SAME TABLE. That they really do belong together is the most important thing to be sure of in data modeling. They need to be "functionally dependent" on the same set of primary key columns. Functional dependency is hugely important to understand and is the basis of good data modeling.
Some authors:
C.J. Date
Fabian Pascal
Sharon Allen
many others as well.
HTH,
Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-982-3081
mbl 801-628-6058
michael.milligan_at_ingenix.com
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Michael Milligan
INET: Michael.Milligan_at_ingenix.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 Tue Oct 21 2003 - 11:29:36 CDT
 |
 |