Consider a relational schema team(name, city, owner), with functional dependencies \{name $\rightarrow$ city, name $\rightarrow$ owner}.
The relation team is decomposed into two relations, $t 1$ (name, city) and $t 2$ (name, owner). Which of the following statement(s) is/are TRUE?
A functional dependency $F: X \to Y$ is termed as a useful functional dependency if and only if it satisfies all the following three conditions:
- $X$ is not the empty set.
- $Y$ is not the empty set.
- Intersection of $X$ and $Y$ is the empty set.
For a relation $R$ with 4 attributes, the total number of possible useful functional dependencies is _________
The symbol → indicates functional dependency in the context of a relational database. Which of the following options is/are TRUE?
Suppose the following functional dependencies hold on a relation U with attributes P, Q, R, S, and T :
P → QR
RS → T
Which of the following functional dependencies can be inferred from the above functional dependencies?