Register

Candidate Keys

866 views
0 0 votes
LastName     Rank    RoomNo          Shift

Kumar        Manager    191               Morning

Prasad      Custodian    20               Afternoon

Singh        Clerical        190             Morning

Kumar       Custodian    20               Evening

 

No of candidate keys in above relation_______________

1 Answer

0 0 votes

5 candiate keys are possible..

Lname,Rank

Lname,RoomNo

Lname,shift

Rank,Shift

RoomNo,Shift

ALL OF ABOVE UNIQUELY IDENTIFY EACH TUPLE..SO ARE CANDIDATE KEYS...

Voting & Accepting an answer helps improve the community
← Previous · B treeNext → · (∀x∀yP(x,y))→(∀x∀yP(...
← Previous in category · B treeNext in category → · Referential Integrit...
Position:
Show:

Related questions

2 2 votes
1 1 answer
185
185 views
GO Classes asked Sep 2
185 views
GO Classes DPP | GATE CS, DA | DBMS | Maximum Candidate Keys
A relation schema $R$ has $6$ attributes.What is the maximum number of candidate keys that $R$ can simultaneously have?
1 1 vote
1 1 answer
344
344 views
Kunjd26 asked Feb 4
344 views
Candidate keys of decomposed relation are computed base on origianl FD set OR base on porojected FD set of that particular decomposed relation?
Let $R$ be a relation schema with a set of functional dependencies $F$.The relation $R$ is decomposed into $n$ relation schemas$R_1, R_2, \ldots, R_n$.Consider the follow...
0 0 votes
1 1 answer
546
546 views
24aaaa23 asked Oct 2, 2023
546 views
CANDIDATE KEYS
Consider a relation R'(P, Q, R, S, T)The functional dependency of the relation R' are as follows –P->QRRS->T”*”->“*” is non empty subset of R'. It may be trivial or non-...
1 1 vote
0 0 answers
1.0k
1.0k views
anupamsworld asked Jul 29, 2022
1,014 views
Finding Candidate Keys | Class Practice | Unacademy
Find the candidate key(s) of the relation R(UVWXYZ) with FD set F={UV >W, XW >Y, U >XZ, Y >U}XWUV, YV, WXVYUV, XV, WVNone of these