GATE CSE
First time here? Checkout the FAQ!
x
+3 votes
21 views

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

asked in GATE by Loyal (2.5k points) 2 6 13 | 21 views
Both !

3 Answers

0 votes
Both
answered by Junior (731 points) 1 1 5
0 votes
Both Will be Candidate key
answered by Boss (5.9k points) 2 6 15
0 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.

answered by Junior (733 points) 1 2 14

Related questions

+3 votes
4 answers
1
asked in Databases by Anirudh Pandey Junior (953 points) 1 7 25 | 78 views
+1 vote
1 answer
2
asked in Databases by Parshu gate Junior (627 points) 1 2 17 | 42 views


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
Top Users Oct 2017
  1. Arjun

    23386 Points

  2. Bikram

    17068 Points

  3. Habibkhan

    8158 Points

  4. srestha

    6286 Points

  5. Debashish Deka

    5438 Points

  6. jothee

    4978 Points

  7. Sachin Mittal 1

    4772 Points

  8. joshi_nitish

    4344 Points

  9. sushmita

    3964 Points

  10. Rishi yadav

    3804 Points


Recent Badges

Ancestor Arijit 2
Good Answer pC
Revival pC
Reader Rajesh R
Reader #Rahul
Popular Question Arnabi
100 Club Rahul68
Popular Question Kanchan kumari
Old-Timer Santanu
Devoted Reader smsubham
27,316 questions
35,170 answers
84,073 comments
33,262 users