retagged by
403 views

1 Answer

Best answer
3 votes
3 votes

1 attribute candidate key: None (Every attribute has 2 tuples same)

2 attribute candidate key: (Last Name, Rank), (Last Name, Room Number), (Last Name, Shift), (Rank, Shift), (Room Number, Shift).

(Rank, Room Number) cannot be a 2 attribute candidate key because (Custodian,20) is there twice. So, if we add one more attribute to it, like (Rank, Room Number, Last Name) or (Rank, Room Number, Shift), it becomes a Superkey.

So, only 5 candidate keys.

selected by

Related questions

0 votes
0 votes
1 answer
1
SKMAKM asked Aug 6, 2022
653 views
Please explain Ans is 22
0 votes
0 votes
1 answer
2
Hradesh patel asked Jan 28, 2017
314 views
#plz chek???
0 votes
0 votes
2 answers
3
Hradesh patel asked Jan 28, 2017
323 views
here answer is 8 or 9??
1 votes
1 votes
0 answers
4
Hradesh patel asked Jan 28, 2017
203 views
#plz explain??