47 views

Can someone explain this please !

I couldn’t get the correct answer.

| 47 views
0
I feel it is none of the above.

0
For primary key constraint, all the values inserted for primary key attribute must be $UNIQUE$ and $\text{NOT NULL}$

For Foreign key constraint, only Updation/Deletion property must be preserved.

Hence all the options A, B, C are possible
0
@Doraemon
Yes, None of these is the correct answer

0
@!KARAN

I thought so but the answer given is Option D
0
On insertion, forgien key values should be already in the original table in which attribute It refers.

Option d is correct.
0
@shaik_masthan sir

in option A, a5 is missing for (a4,a5)

in option B, a3 is missing for (a4,a3)

in option C, a5 is missing for (a4,a5)

like that?

Am I thinking in the correct way?

Let me know if I am wrong.
0
Yes, that's correct way
0
Now, I got it

Thank you @shaik_masthan sir
0
Thanks @Shaik

I completely forgot the property that values occuring for foreign key attributes must come in primary key attribute