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].