Register

Gate Practice Question

614 views
0 votes
0 votes
A relational schema R with attributes (ABCDEFG).It is known that D never appears on RHS of any FD.How many different possibilities are there for what a Candidate key of R can be.?
User Avatar

1 Answer

2 votes
2 votes

By this statement ,"It is known that D never appears on RHS of any FD" , we are assured that D has to be in candidate key. Remaining may or may not be the part of the candiadte key ie. two choices for remaining attributes.

So, 26 = 64 will be total possibilities for CK.

User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
0 answers
1
anupamsworld asked Jul 29, 2022
555 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} XW UV, YV, WXV YUV, XV, WV None of these
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
User Avatar
33 votes
33 votes
4 answers
3
Kathleen asked Oct 5, 2014
8,964 views
GATE CSE 1994 | Question: 3.7
An instance of a relational scheme $R(A, B, C)$ has distinct values for attribute $A$. Can you conclude that $A$ is a candidate key for $R?$
An instance of a relational scheme $R(A, B, C)$ has distinct values for attribute $A$. Can you conclude that $A$ is a candidate key for $R?$
User Avatar
53 votes
53 votes
4 answers
4
go_editor asked Sep 29, 2014
16,576 views
GATE CSE 2011 | Question: 12
Consider a relational table with a single record for each registered student with the following attributes: $\text {Registration_Num:}$ Unique registration number for each registered student $\text {UID:}$ ... that $S \cap \text{UID}$ is $\text{NULL}$ then $S \cup \text{UID}$ is also a superkey
Consider a relational table with a single record for each registered student with the following attributes:$\text {Registration_Num:}$ Unique registration number for each...
User Avatar
Link Copied!