edited by
538 views
2 votes
2 votes

Let R (ABCD) and S(DEF). D is the foreign key in R that references primary key in S. Which of the following will not violation?

a. Insertion in R

b. Insertion in S

c. Deletion from R

d. Deletion from S 

edited by

1 Answer

Best answer
5 votes
5 votes

Here D is foregin key in R...so it can have only those values which are in there in S...

Insertion in R may creates problem if D has value which is not in S......

Insertion in S will not be any problem..

Deletion from R also no problem...

but deletion from S may creates problem..as entry deleted from S may have an instance in R....

so out of all ..B and C will not create any problem 

selected by

Related questions

1 votes
1 votes
1 answer
1
aditi19 asked Jun 7, 2019
1,849 views
How to represent referential integrity constraint in ER model?pls explain with diagram