total participation

From: Shankar Ram Thyagar <srt2_at_acsu.buffalo.edu>
Date: Thu, 12 Apr 2001 11:44:42 -0400
Message-ID: <Pine.GSO.4.05.10104121140110.10493-100000@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,

Thyagarajan Shankar Ram
21 merrimac street
buffalo, NY 14214

ph : 716-837-0715
srt2_at_eng.buffalo.edu

Received on Thu Apr 12 2001 - 10:44:42 CDT