Register

candidate key

4,552 views
2 votes
2 votes

Q1)  R(A1,A2,A3,..................An)  having A1A2 as its candidate key. Find the no of super key..?

Q2)   R(A1,A2,A3,..................An)  having A1 and A2 as its candidate key. Find the no of super key..?

User Avatar

5 Answers

0 votes
0 votes

The no of super keys are :

1. A1A2 is a candidate key so the there are n-2 in (A1A2A3................An) ,therefore the super key is 2(n-2).

2.In this 2nd problem both A1 and A2 are seperate, so that 2(2(n-1))-2(n-2​).

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

Related questions

173
views
1 answers
0 votes
SandeepKumar147 asked Apr 5
173 views
Relation R(A1, A2, A3 ..... An) n attributes. On this relation m simple candidate key (m ≤ n). How many super keys possible in this relation? A. 2m – 1 B. (2n – 1) ⋅ 2n-m C. 2n – 1 D. (2m – 1) 2n-m
User Avatar
116
views
0 answers
0 votes
tbhaxor asked Apr 4
116 views
Can a candidate key for a composite attribute be called a composite key?
Let's take an example of student entity typeNameClassSectionAddress (Line1, Line2, City, State, Country, PinCode)Since composite attribute holds multiple atomic ... combinations like{Class, Section}{Class, Address}{Name, Class, Section}
User Avatar
283
views
1 answers
0 votes
Deepalitrapti asked Aug 9, 2018
283 views
Candidate key
User Avatar
1.5k
views
4 answers
4 votes
Anirudh Pandey asked Sep 19, 2017
1,523 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?
User Avatar
Link Copied!