edited by
5,953 views
7 7 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\}$

2 Answers

Answer:
Position:
Show:

Related questions

14 14 votes
5 5 answers
12.1k
12.1k views
go_editor asked Jul 1, 2016
12,065 views
Consider the following tableThe table is in which normal form?First Normal FormSecond Normal FormThird Normal Form but not BCNFThird Normal Form and BCNF
6 6 votes
2 answers 2 answers
10.6k
10.6k views
Anu asked Jun 28, 2016
10,622 views
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 ...
8 8 votes
4 answers 4 answers
8.2k
8.2k views
Nivetha Ravichandran asked Sep 21, 2015
8,245 views
Consider the schema $R (A, B, C, D)$ and the functional dependencies $A\to B$ and $C\to D$. If the decomposition is made as $R_1(A, B)$ and $R_2 (C, D)$, then which of t...
9 9 votes
1 answers 1 answer
10.1k
10.1k views
ajit asked Sep 5, 2015
10,131 views
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) ...