RE: Useful Oracle books - C.J. Date theory vs. practicality

From: Michael Milligan <Michael.Milligan_at_ingenix.com>
Date: Fri, 28 May 2004 12:33:52 -0500
Message-ID: <BEB4912D93B5D24694F5231821555306014BA0DB@slc7-sstmsx1.pcl.ingenix.com>

In-line

-----Original Message-----
From: Dan Tow [mailto:dantow_at_singingsql.com] Sent: Friday, May 28, 2004 11:17 AM
To: oracle-l_at_freelists.org
Subject: RE: Useful Oracle books - C.J. Date theory vs. practicality

Thanks for the feedback, Lex, nice to hear your view on this. I have a few comments/questions inline, below (also trimming a bit so I don't exceed the quoted-lines limit):

Dan Tow
650-858-1557
www.singingsql.com

> DST: So, how do we handle Spouse_ID for a single person in a Persons
table?

By leaving a NULL for those single folks, we're changing the functional dependency of the column value from the primary key to marital_status, or to include marital_status.

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri May 28 2004 - 12:31:02 CDT