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
- A program compiles successfully but produces incorrect output for certain inputs. What type of error is this most likely to be?
- When evaluating the performance of an algorithm, which of the following factors is generally considered most important for large input sizes?
- Consider the following C++ code: class Base { public: void show() { std::cout
- In C the array index starts from :
- If receiver noise floor is 2 dB, signal-to-noise ratio is 3 dB then what is the receiver sensitivity?
- Consider the following C++ code: int a = 5; int b = 10; if (a > 0 && b < 10) { a = a + b; } else if (a == 5 || b == 10) { ...
- Which property defines a Binary Search Tree (BST)?
- In PAM technique which of the below attributes of the pulse is used to vary as the amplitude of message varies
- If you have MAC address then to know the IP address you will use :
- Consider the following Java code: public class SubstringDryRun { public static void main(String[] args) { String s = "Programming"; ...
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