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].
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
- In a doubly linked list with n nodes, what is the time complexity to delete a node given only a pointer to that node (not the head), and why does this diff...
- The Knuth-Morris-Pratt (KMP) algorithm improves upon the Naive approach by avoiding unnecessary re-comparisons. It achieves this by:
- Which of the following statements about SRAM (Static RAM) is correct?
- The Divide and Conquer paradigm involves three main steps. What are they?
- A process makes a system call to request a resource. If the resource is unavailable, the process will typically transition to which state?
- Which of the following conditions is not necessary for a deadlock to occur
- What does Section 66A of IT Act define?
- In the COCOMO (Constructive Cost Model) model, which mode is used for medium-sized, somewhat complex projects with mixed experience team?
- Which of the following operation is performed by Domain Name Server (DNS)?
- What is the output of the following code? public class Test { public static void main(String[] args) { int[] arr = new int[5]; ...
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
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
- 200 Questions with Detailed Solutions
- Section-wise Coverage (GA, English, Quant & Reasoning)