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 the sentence, identify the segment which contains the grammatical error.
As a consequently, (1)/ some have suffered (2)/ irreversible damag...
He denied to have (A)/any part in writing the information packs (B)/and advertisements and said they (C)/were largely available when he arrived (D).
Each of the following sentences has been divided into five parts (a), (b), (c), (d), and (e). One of these parts may contain a grammatical or idiomatic...
- Find out the error according to the grammar and context of the given sentences. If there is no error, mark option 5, i.e. No error. (Ignore the punctuation...
Each of the following sentences has been divided into five parts (a), (b), (c), (d), and (e) . One of these parts may contain a grammatical or usage er...
Beside giving 1)/ a long and rude scolding 2)/ the lady also gave 3)/ a harsh punishment to the boy 4)/ No Error 5).
The following sentence has been split into four segments. Identify the segment that contains a grammatical error.
He thinks that he can get away ...
From the options given below, select the option which states the correct combination of correct sentences.
I. Each of the participants were req...
It was he who came running in the house with the news about the earthquake.
In the following questions, a sentence is divided into four parts. Choose the part of the sentence which may contain a grammatical error in it. If all ...