Why can a candidate key be null?
Candidate key is the set of attributes by which it is possible to identify each row of the table. Therefore, if some attribute is nullable, it cannot be one of candidate keys. Can a candidate key have a null value? Any attribute of Primary key can not contain NULL value. While in Candidate key any attribute can contain NULL value. …