Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 310 |
From the following instance of a relation scheme R(X,Y,Z), we can conclude that:
X Y Z
1 1 1
1 1 0
2 3 2
2 3 2
| X functionally determines Y and Y functionally determines Z | |
| Y does not functionally determine Z | |
| X does not functionally determine Y and Y does not functionally determine Z | |
| None of the above |
Question 310 Explanation:
From the given instanceof relation it can be seen that X functionally determines Y, but we cannot conclude this for the entire relation.
But for the given instance it can be seen that Y does not functionally determines Z, and it can be concluded for the entire relation
But for the given instance it can be seen that Y does not functionally determines Z, and it can be concluded for the entire relation
Correct Answer: B
Question 310 Explanation:
From the given instanceof relation it can be seen that X functionally determines Y, but we cannot conclude this for the entire relation.
But for the given instance it can be seen that Y does not functionally determines Z, and it can be concluded for the entire relation
But for the given instance it can be seen that Y does not functionally determines Z, and it can be concluded for the entire relation