#normalization

Question

Comments

only three CK are possible

Answer 1

3 CK possible.

1. S.no

2. Marks

3. {Name,Age}

Comments

why not  {SNO,Age} is candidate key ?

---

Already SNO is a Candidate key, so anything more with SNO will be turn out as SuperKey.

---

okay

Answer 2

3 keys are possible for given instance....

S.no is 1 st candidate key as uniquely identify each row...

Marks is 2 nd candidate key as uniquely identify each row...

{NAME,AGE} is 3rd  candidate key as uniquely identify each row...