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
- Consider the following Java code: public class LengthMix { public static void main(String[] args) { int[] numbers = {10, 20, 30, 40}; ...
- A priority queue is a special type of queue where each element has a priority. What is the typical time complexity for inserting an element into a priority...
- What is the relationship between encapsulation and abstraction?
- Which of the following statements best describes a "trap door" in the context of computer security?
- What is the main purpose of Inheritance in OOP?
- MAC Address size is :
- A Java method attempts to extract a substring. public class StringProcessor { public String extractPart(String text, int start, int length) { ...
- What is the keyword used in Java to indicate that a class is inheriting from another class?
- Which network security device typically enforces a policy based on IP, port and protocol and can operate at transport and application layer when deep inspe...
- Consider the following C code snippet: #include int recursiveSum(int n) { static int sum = 0; // Static variable if (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
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)