Question
Which functional dependency does not holds in given
relation 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
v->wx satisfies condition 3 i.e. value of v is repeated 3 times ( 7 ) then value of wx is also repeated . so option 1 is correct. yz->x satisfies condition 2, i.e. all values of x are same, so option 2 is correct. x ->yz does not satisfy any of the three conditions, so option 3 is incorrect.
- Select the option that expresses the given sentence in active voice.
The documents were not signed by the manager.
... Find the correctly spelt word.
Select the correct passive form of the given sentence.
A brick falling from the roof top broke the front glass of my car.
Select the correct active form of the given sentence.
This beautiful story was written by Maya.
Select the option that expresses the given sentence in passive voice.
A child could understand his theory.
The cake was eaten by the children.
The problem is that there is no good way to_________data from the hundreds of millions of establishments.
He recommended using the bullet proof car.
The hanging of the murderer of Mrs Gandhi was seen by many.
Select the correct passive voice of the given sentence.
The Enforcement Directorate has seized a 22-room sprawling seaside farmhouse in Alibaug.