+14 votes
598 views

Let $R = (A, B, C, D, E, F)$ be a relation scheme with the following dependencies $C \rightarrow F, E \rightarrow A, EC \rightarrow D, A \rightarrow B$. Which one of the following is a key for $R$?

1. CD
2. EC
3. AE
4. AC
asked | 598 views

## 1 Answer

+18 votes
Best answer
Answer: B

EC is the key for R. Both E and C are not coming on the right hand side of any functional dependency. So, both of them must be present in any key. Now, with EC and the given FDs, we can derive all other attributes making EC a key.
answered by Boss (34k points)
selected
Answer:

+12 votes
8 answers
1
+12 votes
3 answers
2
+12 votes
2 answers
3
+22 votes
3 answers
4
+12 votes
1 answer
5
+30 votes
6 answers
6
+24 votes
4 answers
7