Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Implementing complicated constraints
On 29 Sep 2004 10:21:38 -0700, Tony Andrews wrote:
> Brian Dick wrote:
>> On 28 Sep 2004 08:11:44 -0700, Tony Andrews wrote: >>> Of course, having the CID in the A table is a viable work-around,
>>> that doesn't mean there was a relational design flaw before. >> >> You need to brush up on your normalization rules. Rule 3 states that >> columns must be dependent on nothing but the key. Your ATXT column is
>> solely dependent on AID, so your design is not normalized.
Mark C. Stock gave you a possibility. Although, his model implies that A is dependent on B is dependent on C. Is A.BID or B.CID nullable? If so, then Mark's model is not correct either. Need more info about the problem. Received on Wed Sep 29 2004 - 15:47:29 CDT