Re: total participation

From: Alan Shein <alanshein_at_spambuster.erols.com>
Date: Thu, 12 Apr 2001 14:25:05 -0400
Message-ID: <9b4rs4$77h$1@bob.news.rcn.net>

Why would you want to implement it without a key constraint?

"Shankar Ram Thyagar" <srt2_at_acsu.buffalo.edu> wrote in message news:Pine.GSO.4.05.10104121140110.10493-100000_at_ming.eng.buffalo.edu...
>
> Hi guys,
> iam having a tough time implementing this seemingly basic/simple case in
> oracle.
> how do i implement a total participation without a key constraint?
> say, I have two entity tables A and B. these two tables are realted by a
> many to many relationship table C. But, A has total partitcipation in the
> relationship.
> How do i ensure this?
> unfortunately, oracle does not support ASSERTIONS and CHECK with
> subqueries.
> prompt replies will be of great help.
> thanks in advance,
> - Ram
>
> ============================
>
> Thyagarajan Shankar Ram
> 21 merrimac street
> buffalo, NY 14214
>
> ph : 716-837-0715
> srt2_at_eng.buffalo.edu
>
> ============================
>
>
Received on Thu Apr 12 2001 - 13:25:05 CDT