Q20

MCQ1 mark, −0.33

Consider the relation $X(P,Q,R,S,T,U)$ with the following set of functional dependencies $F = \{ \\ \; \; \{P, R\} \rightarrow \{S, T\}, \\ \; \; \{P, S, U\} \rightarrow \{Q, R\} \\ \; \}$ Which of the following is the trivial functional dependency in $F^+$ , where $F^+$ is closure to F?

(A)

$\{P, R\} \rightarrow \{S, T\}$

(B)

$\{P, R\} \rightarrow \{R, T\}$

(C)

$\{P, S\} \rightarrow \{S\}$

(D)

$\{P, S, U\} \rightarrow \{Q\}$

Loading…