4,009 views

1 Answer

Best answer
31 votes
31 votes
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.
selected by
Answer:

Related questions

38 votes
38 votes
1 answer
2
Kathleen asked Sep 23, 2014
16,790 views
Consider the join of a relation $R$ with a relation $S$. If $R$ has $m$ tuples and $S$ has $n$ tuples then the maximum and minimum sizes of the join respectively are$m+n$...
3 votes
3 votes
3 answers
3
go_editor asked Feb 8, 2018
1,793 views
Consider the set of relationsEMP (Employee-no. Dept-no, Employee-name, Salary)DEPT (Dept-no. Dept-name, Location)Write an SQL query to:Calculate, for each department numb...