{Name, Registration_no}:This key cannot be considered as a candidate key because when we take the subset of this key we get two attributes i.e Registration_no or Name. Registration_no is a candidate key. So, it is not a minimal super key. Hence, this key is not a candidate key. {...
Here, we will be discussing about candidate key, its role, as well as its use. We will also look at some examples that will make us to better understand the concept of a candidate key. What is a Candidate Key A candidate key is a subset of a super key set where the key which cont...
As we have talked in the above step only for the super key, not for the candidate key. Let us see the definition of Candidate Key again (Candidate Key is a Super Key whose no proper subset is a superkey) From the above definitionXY is a candidate key, as in Step 2 and 3 none of...