in Databases edited by
283 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 

in Databases edited by
283 views

1 Answer

4 votes
4 votes
Best answer

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

1 comment

Pls see Gate1997_6.10, isro2016-54.
Similar type of question is asked .
0
0

Related questions