Register

dbms candidate keys

1,126 views
0 votes
0 votes

User Avatar

3 Answers

2 votes
2 votes
5

lastnameRank, LastnameRoomnumber, LastnameShift, RankShift, RoomnumberShift
User Avatar
1 votes
1 votes
$\alpha -> \beta$

For same $\alpha$ , $\beta$ should be unique.

None of the attributes on their own can determine all other attributes uniquely. So we have CK that are a combination of attributes.

CK are
lastnameRank, LastnameRoomnumber, LastnameShift, RankShift, RoomnumberShift

So the answer is 5.
User Avatar
0 votes
0 votes
Shouldn't there be 9 candidate keys?
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

5 votes
5 votes
3 answers
1
GateAspirant999 asked Oct 29, 2016
2,399 views
Number of minimal candidate keys
A relation R(A,B,C,D,E,F) holds following FDs $AB\rightarrow C$ $C\rightarrow D$ $D\rightarrow EA$ $E\rightarrow F$ $F\rightarrow B$ The number of minimal candidate keys of R are _______.
A relation R(A,B,C,D,E,F) holds following FDs$AB\rightarrow C$$C\rightarrow D$$D\rightarrow EA$$E\rightarrow F$$F\rightarrow B$The number of minimal candidate keys of R a...
User Avatar
4 votes
4 votes
4 answers
2
Anirudh Pandey asked Sep 19, 2017
1,402 views
Random Doubt, Candidate Key, DBMS
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?
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?
User Avatar
2 votes
2 votes
2 answers
3
Parshu gate asked Sep 17, 2017
1,129 views
CANDIDATE KEY
User Avatar
Link Copied!