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

Home -> Community -> Usenet -> comp.databases.theory -> Re: primary and foregin keys

Re: primary and foregin keys

From: <ak_tiredofspam_at_yahoo.com>
Date: 25 Dec 2004 19:20:52 -0800
Message-ID: <1104031252.387696.253800@f14g2000cwb.googlegroups.com>


>> ... in an RDBMS, one kind of entity should be in a one and
nly one table. ...<<

should you say "... should USUALLY be in a one ... ", everybody would agree.

We all know that there are some exceptions, most notably a well known approach to open a new SALES table every quarter, then purge old data by dropping the oldest one. Received on Sat Dec 25 2004 - 21:20:52 CST

Original text of this message

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