Question
Which functional dependency holds in given relation R
(A, B, C) and why? Read the below passage and answer the questions Functional dependency A B means that B is dependent on A i.e. from the value of A we can find the value of B from the relation. Therefore, to prove A B holds in a relation, one of the following conditions must be true: Condition1: either all the value of A must be unique Or Condition2: all the value of B must be same Or Condition3: If two or more tuples/rows of the relation have same value for attribute A then there must be also same value for attribute B i.e. if t1[A] = t2[A] then there must be t1[B] = t2[B].Solution
AB ->C satisfies condition1 (all the values of AB are unique), but C->B does not satisfy any of the three conditions (C has not unique values, B has not all same values and the value of C is repeated two times (8, 5) then the value of B is not repeated), so option 1 is incorrect. B->C A satisfies condition1, and B-> C also satisfies condition1, so option 2 is correct. B->C A satisfies condition1, but A->C does not satisfy any of the three conditions, so option 3 is incorrect. A->C B does not satisfy any of the three conditions, and B-> C satisfies condition1, so option 4 is incorrect. Since BC ->A && B ->C holds in above relation, option 2 will be the answer.
In which year the First Financial Stability Report was released?
According to the Forbes List of America’s Richest Self-Made Women, which of these has topped it?
Match List-I with List-II and choose the correct answer from the codes below:
Which two organizations signed an MoU to establish Jan Aushadhi Kendras in coalfield areas?
Which of the following missile was built in India with Russian collaboration?
Which of the following states has recently inaugurated its own Olympic?
Ghughua Fossil National Park is in which state?
For an instant electronic fund transfer service that allows inter and intra-bank transfers within seconds to the customer account is a concept of?
Which city hosted the 5th ASEAN-India Trade in Goods Agreement (AITIGA) joint committee meeting?
This year India marks the Golden jubilee celebration of formal diplomatic relation between India and: