Register

ISRO2014-42

• edited by
4,343 views
2 votes
2 votes

Let $x,y,z,a,b,c$ be the attributes of an entity set E. If $\{x\} ,\{x,y\}, \{a,b\},\{a,b,c\}, \{x,y,z\}$ are superkeys then which of the following are the candidate keys?

  1. $\{x,y\}$ and $\{a,b\}$
  2. $\{x\}$ and $\{a,b\}$
  3. $\{x,y,z\}$ and $\{a,b,c\}$
  4. $\{z\}$ and $\{c\}$
• edited by
User Avatar

2 Answers

Best answer
8 votes
8 votes
Minimal superkey is candidate key

{x} and {ab } are candidate keys....
User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

10 votes
10 votes
4 answers
1
go_editor asked Jul 1, 2016
8,413 views
ISRO2014-63
Consider the following table The table is in which normal form? First Normal Form Second Normal Form Third Normal Form but not BCNF Third Normal Form and BCNF
Consider the following tableThe table is in which normal form?First Normal FormSecond Normal FormThird Normal Form but not BCNFThird Normal Form and BCNF
User Avatar
6 votes
6 votes
2 answers
2
Anu asked Jun 28, 2016
6,593 views
ISRO2014-11
An aggregation association is drawn using which symbol? A line which loops back on to the same table A small open diamond at the end of a line connecting two tables A small closed diamond at the end of a line connecting two tables A small closed triangle at the end of a line connecting two tables
An aggregation association is drawn using which symbol?A line which loops back on to the same tableA small open diamond at the end of a line connecting two tablesA small ...
User Avatar
7 votes
7 votes
1 answer
4
ajit asked Sep 5, 2015
6,699 views
ISRO2014-30
Every time the attribute A appears, it is matched with the same value of attribute B but not the same value of attribute C. Which of the following is true? A -> (B,C) A -> B, A ->> C A -> B, C ->> A A ->> B, B -> C
Every time the attribute A appears, it is matched with the same value of attribute B but not the same value of attribute C. Which of the following is true?A - (B,C) ...
User Avatar
Link Copied!