2,137 views
0 votes
0 votes
let x y z a b c be the attributes of an entity set.E.if {x},{x,y},{a,b},{a,b,c},{x,y,z} are superkeys then which of the following is candidate key?

a){x,y} and {a,b]

b){x} and {a,b }

c){x,y,z} and {a,b,c}

d){z} and {c}..with explanation

2 Answers

1 votes
1 votes

Option B

How ?

Candidate keys are a special subset of super keys that do not have any extraneous information in them.

0 votes
0 votes

candidate keys : if any proper subset of super key is also a super key then that Sk is not a candidate key,

so here .. x, xy , ab  , abc  ,xyz  .... these are Sk,  

for example 

x is proper subset of xy so, xy is not a candidate key BUT x is a Sk 

according to me Ckeys are   x,  ab  , 

SO OPTION B IS ANSWER

No related questions found

Total PHP MySQL Other RAM
Time (ms) % Time (ms) % File count Time (ms) % Query count Time (ms) % Amount %
Setup 3.8 4% 2.4 3% 72 1.5 1% 2 0.0 0% 569k 53%
Control 13.1 16% 1.4 1% 5 12.0 15% 12 0.0 0% 175k 16%
View 1.4 1% 1.4 1% 12 0.0 0% 0 0.0 0% 90k 8%
Theme 52.1 66% 3.7 4% 15 48.5 61% 2 0.0 0% 230k 21%
Stats 8.0 10% 0.1 0% 0 8.0 10% 1 0.0 0% 0k 0%
Total 78.4 100% 9.0 11% 104 69.9 89% 17 0.0 0% 1066k 100%