NTA UGC NET JUNE 2023 Paper-1
January 4, 2024Question 11274 – Prefix-Postfix-Expression
January 4, 2024Database-Management-System
| Question 99 |
Given the following relation instance.
x y z
1 4 2
1 5 3
1 6 3
3 2 2 Which of the following functional dependencies are satisfied by the instance?
| XY → Z and Z → Y | |
| YZ → X and Y → Z | |
| YZ → X and X → Z | |
| XZ → Y and Y → X |
Question 99 Explanation:
A functional dependency A→B is said to hold if for two tuples t1 and t2.
If for t1[A] = t2[A] then t1[Y] = t2[Y].
If for t1[A] = t2[A] then t1[Y] = t2[Y].
Correct Answer: B
Question 99 Explanation:
A functional dependency A→B is said to hold if for two tuples t1 and t2.
If for t1[A] = t2[A] then t1[Y] = t2[Y].
If for t1[A] = t2[A] then t1[Y] = t2[Y].