retagged by
657 views
0 votes
0 votes

Please explain   

Ans is 22

retagged by

1 Answer

Best answer
1 votes
1 votes
Total Keys Possible = $2^5$ = 32

Candidate Key is Minimal Super Key. There can be multiple CK’s.

We select any one key of our choice from CK’s and call it as primary key of the table.

Candidate Keys:

CITY => not possible (As CITY,COUNTRY is a candidate key already)

COUNTRY => not possible(same reason)

Anything added with CITY,COUNTRY is also not possible as we want minimal superkey. Here, we have 8 possibilities.

Possible Candidate Keys = $32 – 2 – 8 = 22$
selected by

Related questions

0 votes
0 votes
1 answer
1
firki lama asked Jan 16, 2017
405 views
3 votes
3 votes
2 answers
2
Bikram asked Aug 26, 2017
723 views
A relation $R(P,Q,R,S)$ has $\{PQ, QR, RS, PS\}$ as candidate keys. The total number of superkeys possible for relation $R$ is ______