I am trying to understand how to find minimal keys. The assignment provides me with the following task:
Find 3 minimal keys in relation (each key is a set of attributes).
R (a, b, c, d, e)
a -> b
bc -> d
de -> a
The answer is:
(a, c, e)
(b, c, e)
(d, c, e)
I do not understand how to get to the answer. I would appreciate any guidance.
First of all, this website by Griffith University helped a lot ( they also show step by step BNCF normalization).
Apparently, in this task minimal key is a candidate key.
First step is to find attributes that exist in the relation R but not on the RightHandSide.
The second step is to find closures of the current candidate key. Closure of {c e} is {c e}. This does not help, therefore we need to include an extra attribute. We start from the (alhabetical) beginning: