in GATE
516 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? 

in GATE
516 views

1 comment

Both !
1
1

2 Answers

1 vote
1 vote

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.

0 votes
0 votes
Both Will be Candidate key
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

64.3k questions

77.9k answers

244k comments

80.0k users