Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: total participation
I'm going with Alan on this one. What possible reason could there be for no using a constraint unless you like pain and suffering.
But I should point out that Many-to-Many relationships are a clear sign of a bad design. You should have an intersecting entity between the two tables consisting of the primary keys from each.
Daniel A. Morgan
Alan Shein wrote:
> 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 - 22:42:51 CDT