edited by
6,485 views
7 votes
7 votes

Consider the following database table having $\text{A, B, C}$ and $\text{D}$ as its four attributes and four possible candidate keys $\text{(I, II, III and IV)}$ for this table :

$\begin{array}{|l|l|l|l|} \hline \text{A} & \text{B} & \text{C} & \text{D} \\ \hline \text{$a_1$} & \text{$b_1$} & \text{$c_1$} & \text{$d_1$}  \\ \hline \text{$a_2$} & \text{$b_3$} & \text{$c_3$} & \text{$d_1$}  \\ \hline  \text{$a_1$} & \text{$b_2$} & \text{$c_1$} & \text{$d_2$}  \\ \hline \end{array}$

$\begin{array}{} \text{I : {B}} & \text{II : {B, C}} & \text{III : {A, D}} & \text{IV : {C, D}} \end{array}$

If different symbols stand for different values in the table $(\text{e.g.,}\; d_1$ is definitely not equal to $d_2),$ then which of the above could not be the candidate key for the database table?

  1. $\text{I}$ and $\text{III}$ only
  2. $\text{III}$ and $\text{IV}$ only
  3. $\text{II}$ only
  4. $\text{I}$ only
edited by

2 Answers

Best answer
8 votes
8 votes
Ans is C

1:(B)

2: ((B,C)

3: (A,D)

4: (C,D)

1 is definetly canidate key

2 BC canot be candidate key because it is Superset of candidate key(B) thats why it is superkey

3 AD is candidate key it is minimal superkey

4 CD is also candidate key it is also minimal superkey
selected by
0 votes
0 votes
Candidate Key Is a minimal Super Key Then If B is a Candidate Key ,  How possible That BC is Also A Candidate  Key

 

 

option B is Not Possible As a candidate key

So, correct option is B
Answer:

Related questions

4 votes
4 votes
1 answer
4
go_editor asked Aug 14, 2016
2,551 views
In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as:Referential integrityMulti-valued dependencyEntity integrityFunctional dependency