search
Log In
0 votes
111 views

I feel that answer is none of the above , because in question it is given AB is key , so any partial dependency will not be accepted , so none will be in 2NF.

what you say , anyways the answer in booklet is D

in Databases 111 views

1 Answer

3 votes
 
Best answer
A. $A \to C$, $C$ is non-key attribute. $AB$ is candidate key and so is a partial FD. Hence, not in 2NF.

B. Here, $C\to B$ makes $AC$ also a candidate key. So, $B \to C$ and $C \to B$ are not violating 2NF as they are detrmining "key" attribute. But $A \to D$ violate 2NF.

C. $AB$ and $DB$ are candidate keys here. Due to $C \to D$, $CB$ also becomes a candidate key. So, no other attribute present other than prime(key) attributes. So, $R$ is in 2NF as well as 3NF.

D. Only $AB$ is the candidate key. $BC$ is not a super key, is also not a proper subset of candidate key. $D$ is not a prime attribute. So, $BC \to D$ violate 3NF but due to no partial dependency, $R$ is in 2NF.

So, D is the answer.

selected by
1

in d option what he( Who asked)  think in BC B is prime then  he think BC combine is prime. :) 

0
but sir question says AB is primary key ,so how BC->D doesnot violate the 2NF?
0
Because BC is not a proper subset of AB as C is not there is AB. Only B and A are proper subset of AB

Related questions

3 votes
1 answer
1
3.2k views
https://www.change.org/p/iit-kanpur-gate-gate-2015-please-re-apply-fair-normalization-process-or-give-explanation-about-the-set-2-normalization?recruiter=88980546&utm_source=share_petition&utm_medium=facebook&utm_campaign=share_facebook_responsive&utm_term=des-lg-share_petition-no_msg
asked Jul 27, 2015 in GATE Application Arjun 3.2k views
0 votes
1 answer
2
54 views
Consider the following subquery on the relation R(A,B,C,D) SELECT […..] FROM R GROUP BY A,B Assuming A,B,C,D take integer values, which of the following can appear in the position marked as […..] MIN(C+D) A,B C,D 2 only 1 and 2 only 1,2,3 none
asked Nov 28, 2018 in Databases Ajit J 54 views
0 votes
0 answers
3
316 views asked Jun 20, 2017 in Databases joshi_nitish 316 views
2 votes
1 answer
4
173 views
The schedule S: T1: Read(X); T2: Write(X); T2: Write(Y); T3: Write(Y); T1: Write(Y); T1: commit; T2: commit; T3: commit; is Recoverable or non-recoverable?
asked Sep 16, 2016 in Databases tvkkk 173 views
...