| http://www.w3.org/ns/prov#value | - @Nabeel, In your example, if BC is a candidate key then B->D is a partial key dependency and therefore R is not in 2NF. If a relation has more than one candidate key then it does not matter which you call primary - the choice is arbitrary and does not make any fundamental or practical difference.
|