Awesome q2a theme
0 votes

Can someone explain this please !

I couldn’t get the correct answer.

in Databases by (577 points) | 28 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.

Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Top Users Oct 2019

    410 Points

  2. Satbir

    317 Points

  3. Rudr Pawan

    163 Points

  4. srestha

    132 Points

  5. Mk Utkarsh

    127 Points

  6. Debapaul

    94 Points

  7. chandrikabhuyan8

    83 Points

  8. Shaik Masthan

    79 Points

  9. Verma Ashish

    77 Points

  10. !KARAN

    74 Points

Monthly Top User and those within 60% of his/her points will get a share of monthly revenue of GO subject to a minimum payout of Rs. 500. Current monthly budget for Top Users is Rs. 450.
1,680 questions
1,088 answers
89,591 users