Teaching HPSC Lecturer (Technical) Mock Test 2024 DBMS Integrity Constraints and Normal Form Functional Dependency
Consider the relation X(P, Q, R, S, T, U) with the following set of functional dependencies
F = {
{P, R} → {S, T},
{P, S, U} → {Q, R}
}
Which of the following is the trivial functional dependency in F+, where F+ is closure of F?
1
{P, R} → {S, T}
2
{P, R} → {R, T}
3
{P, S} → {S}
4
{P, S, U} → {Q}
5
Question Not Attempted