Awesome q2a theme
0 votes

Can someone explain this please !

I couldn’t get the correct answer.

in Databases by (778 points) | 47 views
I feel it is none of the above.

What is the answer?
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
Yes, None of these is the correct answer

Can you please explain?

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

Option d is correct.
@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.
Yes, that's correct way
Now, I got it

Thank you @shaik_masthan sir
Thanks @Shaik

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

Please log in or register to answer this question.

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Top Users May 2020
  1. Kushagra गुप्ता

    97 Points

  2. praveen modala

    15 Points

  3. ramcharantej_24

    15 Points

  4. abhishek tiwary

    12 Points

  5. srestha

    12 Points

  6. Dtiwari

    9 Points

  7. Shivateja MST

    8 Points

  8. ankitgupta.1729

    8 Points

  9. Rashimdixit

    7 Points

  10. Bhavya1902

    7 Points

7,376 questions
1,741 answers
90,352 users