502 views
3 votes
3 votes

If A+ and BC+ both produces all the attributes of the relation then candidate key would be A? or both A and BC? 

2 Answers

1 votes
1 votes

You have to keep in mind that there can be more than one candidate key in a relation. It is the primary key that is one among those candidate keys.

So, as both A+ and BC+ both produces all the attributes of the relation then both of them are the candidate keys.

Related questions

0 votes
0 votes
1 answer
1
Deepalitrapti asked Aug 9, 2018
254 views
4 votes
4 votes
4 answers
2
Anirudh Pandey asked Sep 19, 2017
1,331 views
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?
2 votes
2 votes
2 answers
3
Parshu gate asked Sep 17, 2017
1,107 views
0 votes
0 votes
1 answer
4
Akash007 asked Sep 16, 2017
1,036 views
As Candidate key allow NULL value if two record have NULL value then how we identify the record uniquely. Plzz explain the concept