Question

Which is the candidate key for the relation R(ABCDE) with functional dependencies F=A→BC, B→D, CD→E, E→A?
 

• A. A
• B. CD
• C. B
• D. E

Hint:

Understanding candidate keys and functional dependencies is crucial in database normalization to ensure data integrity and reduce redundancy.

Answer 1

The Correct Option is A

From the given functional dependencies, we can derive that \( A \) is sufficient to determine all attributes. Since \( A \to BC \), and \( B \to D \), and \( E \to A \), all attributes are covered by \( A \). Therefore, \( A \) is a candidate key.