Database functional dependency candidate keys

relational-theory

How do you know when you found all the candidate keys in a functional dependency?

I know how i would go about finding a candidate key, just don't know how to tell if there are more.

Thanks.

Best Answer

If you're talking about identifying candidate keys for relational synthesis you need to know the dependencies. If you have the functional dependencies you can use the relational synthesis algorithm; a synopsis of which can be found here.

Note, if this is a homework question please mark it as such in the tags.