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].
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].
More IT Operating System Questions
- Which probability distribution is most widely used to model quantization noise in pulse code modulation ?
- Which of the following best describes a gateway in Computer Networks?
- What is the output of the following Java code? public class LoopTest { public static void main(String[] args) { int x = 0; ...
- What is the primary function of a gateway in a network?
- Consider the following C code snippet: #include int recursiveSum(int n) { static int sum = 0; // Static variable if (n >...
- In which of the following scenarios would the Floyd-Warshall algorithm be most suitable?
- Complete the C function to copy at most n characters from source starting at start_index into destination, ensuring destination is null-terminated. Assume ...
- Which model uses probability of word occurrence based on previous n-1 words?
- Which of the following scheduling algorithms can lead to "starvation" of processes?
- The result of a SQL SELECT statement is a(n) :
Hey! Ask a query
Please enter email id
The email must be a valid email address.
Please enter Mobile Number
Please enter valid Mobile Number
Please enter your Doubt