1
GATE AI 2025
MCQ (More than One Correct Answer)
+2
-0

Consider a database relation $R$ with attributes ABCDEFG , and having the following functional dependencies:

$$ \mathrm{A} \rightarrow \mathrm{BCEF} \quad \mathrm{E} \rightarrow \mathrm{DG} \quad \mathrm{BC} \rightarrow \mathrm{~A} $$

Which of the following statements is/are correct?

A
A is the only candidate key of R
B
A, BC are the candidate keys of R
C
A, BC, E are the candidate keys of R
D
Relation R is not in Boyce-Codd Normal Form (BCNF)