Dear All,
First Question:
I have maintained cardinal relation as C:CN between the non key field of the foreign key table with a check table.
Actually for n = C, each record in the foreign key table refers to zero or one records in the check table. That means we can insert a record into foreign key table even though the record does not present in check table. But when I am inserting a record into foreign key table which is not present in the check table, system stating the record is not there in check table.
Second Question:
I have also checked the cardinality with 1:CN,. Actually for n=1, each record in the foreign key table refers to exactly one record in the check table. If the application program deletes a row from the check table it will also delete the corresponding rows from the foreign key table. I ahve tried it by deleting the record in check table but still the corresponding record in the foreign key table exists.
Please make me clear about this.
Thanks and Regards,
Sri Suktha.
Edited by: srisuktha on Feb 16, 2011 2:34 PM