Register

Super key

380 views
0 votes
0 votes
Consider the relation R(A,B,C,D,E) with the following depencies ABC - DE and D-AB The number of super key of R is
User Avatar

1 Answer

0 votes
0 votes
CD and ABC is the key  here
So, Number of Super keys will be 2^(n-2) + 2^(n-3) - 2^(n-4)

which comes out to be 10

Correct me if Wrong
User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
3 answers
2
Na462 asked May 12, 2018
1,453 views
Super Key 1
Consider the following relational schema R(ABCDE). The number of super keys in relation R if every two attributes of relation R is candidate keys are __________. Please explain a general method to solve
Consider the following relational schema R(ABCDE). The number of super keys in relation R if every two attributes of relation R is candidate keys are __________.Please ex...
User Avatar
1 votes
1 votes
1 answer
3
hacker16 asked Jan 17, 2018
2,677 views
No of Super Key
R (A1, A2, ….An) and every (n-2) attributes of R forms a candidate key. How many super keys are there in R? a) $_{n-2}^{n}\textrm{C}$ b) $_{n-2}^{n}\textrm{C}$ * 4 c) $_{n-2}^{n}\textrm{C}$ * n d) $_{n-2}^{n}\textrm{C}$ + n +1
R (A1, A2, ….An) and every (n-2) attributes of R forms a candidate key. How many superkeys are there in R?a) $_{n-2}^{n}\textrm{C}$b) $_{n-2}^{n}\textrm{C}$ * 4c) $_{n-...
User Avatar
7 votes
7 votes
1 answer
4
Lakshman Bhaiya asked Sep 5, 2017
600 views
No. of super key
$R=(A,B,C,D,F,H)$ Candidate key$=(AEH, BEH, DEH)$ How many super key possible?
$R=(A,B,C,D,F,H)$Candidate key$=(AEH, BEH, DEH)$How many super key possible?
User Avatar
Link Copied!