The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
+1 vote
121 views

Is the following FD in 2NF?

AB -> C                            

Where BD is candidate key.

please explain why this FD is in 2NF.

non-prime,prime ----> non-prime is in 2NF. But why?

Bcz.  as per my knowledge

Every non-prime attribute should be fully functionally dependent on the primary key of R

asked in Databases by Loyal (7.9k points) | 121 views
0
Think

what if AB is also candidate key ?
0
Then it satisfies 2NF
0
Yes, you are correct, it won't violate 2 NF unless either a or b or d derives any other attribute
0
Man, I'm still in confusion. What should I conclude then ?
0
You should check that

1)AB is candidate key or not

if yes then check that from all the possible FD, only single A or B or C is able to derive any attribute

                   if yes then not in 2 NF

                   Else no then relation is in 2NF
0

Check out this question asked in gate-2008

https://gateoverflow.in/492/gate2008-69

Here, {Catalog_no, ( Title , Author )} are candidate keys.

1.Catalog_no --> {Title , Author , Publisher , Year } 

2.{Publisher , Title , Year} --> Price

Which implies, Catalog_no --> Price.

Is it the reason for considering the relation to be in 2NF??

+1
yes you are correct it is because of transitive dependency

Please log in or register to answer this question.

Related questions

+1 vote
0 answers
1
asked Aug 28, 2016 in Databases by Madhab Active (4.1k points) | 65 views
+1 vote
0 answers
2
asked Aug 26, 2017 in Linear Algebra by sid1221 Active (3.6k points) | 167 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

36,075 questions
43,521 answers
123,661 comments
42,747 users