Search code examples
mysqlsqldatabaserelational-databasefunctional-dependencies

What are the candidate keys in the below relation


R(A,B,C,D,E) Functional Dependencies = {AC->E,B->D,E->A}

I know ABC is a candidate key.Can BC be a candidate key too?


Solution

  • The definition of "candidate key" is a superkey that does not contain another superkey. So a candidate key does not contain another candidate key.