1,880 views
1 votes
1 votes

A candidate key should have unique values and a chosen CK is called primary key. Null is also unique. Why (C) is not answer?

4 Answers

2 votes
2 votes

The best answer here is d)none

Candidate key can have NULL values(not just one NULL, there can be several NULLs)

Read this excerpt from KORTH

1 votes
1 votes
Basically null values are considered when we dont know the actual value...  so we can say that null values are not comparable..(arithmetic operation can't be performed on null as they are incomparable.. )
Now here in your question they have asked that which of the following is false... so  (c) option will be better choice over here because eventually candidate key is minimal of primary key and primary keys doesn't not contain null values because it can cause loss of data .. as you are saying null is unique value we can't say that bcz its value is unknown so it may or may not be unique... so answer here will be option C.(Bcz passport number can not be CK as it contains null)
0 votes
0 votes
Answer is D) None.

Because candidate keys can be Null but the chosen primary key from the candidate keys can’t be Null.

Related questions

0 votes
0 votes
1 answer
1
Deepalitrapti asked Aug 9, 2018
254 views
4 votes
4 votes
4 answers
2
Anirudh Pandey asked Sep 19, 2017
1,331 views
If A Relation R(A,B,C,D) and CK given is (AB,C)and FD is given as A->C Then the relation is in which highest normal form?
2 votes
2 votes
2 answers
3
Parshu gate asked Sep 17, 2017
1,107 views
0 votes
0 votes
1 answer
4
Akash007 asked Sep 16, 2017
1,036 views
As Candidate key allow NULL value if two record have NULL value then how we identify the record uniquely. Plzz explain the concept