Set of solved exercises in Normalization / Normalization Solved Examples / How to find candidate keys, and primary keys in database? / Sets of examples to find the keys of a tables / Process of Key finding in a database – Examples
- The closure of F, i.e., (F)+ = FIJ ≠ EFGHIJKLMN. Hence F is not a candidate key. [Refer, How to find closure]
- (EF)+ = EFGIJ ≠ EFGHIJKLMN. Hence EF is not a candidate key.
- (EH)+ = EHKLMN ≠ EFGHIJKLMN. Hence EH is not a candidate key.
- (K)+ = KM ≠ EFGHIJKLMN. Hence, K is not a candidate key.
- (EFH)+ = EFGHIJKLMN = R.