GATE CSE
First time here? Checkout the FAQ!
x
0 votes
40 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 (483 points)   | 40 views
Think

what if AB is also candidate key ?
Then it satisfies 2NF
Yes, you are correct, it won't violate 2 NF unless either a or b or d derives any other attribute
Man, I'm still in confusion. What should I conclude then ?
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

Check out this question asked in gate-2008

http://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??

 

yes you are correct it is because of transitive dependency

Please log in or register to answer this question.

Related questions

0 votes
0 answers
1
asked in Databases by Madhab Loyal (5k points)   | 55 views


Top Users Aug 2017
  1. Bikram

    5272 Points

  2. ABKUNDAN

    4730 Points

  3. akash.dinkar12

    3514 Points

  4. manu00x

    3492 Points

  5. rahul sharma 5

    3188 Points

  6. makhdoom ghaya

    2700 Points

  7. just_bhavana

    2432 Points

  8. stblue

    2244 Points

  9. Tesla!

    2090 Points

  10. pawan kumarln

    1876 Points


25,071 questions
32,226 answers
75,103 comments
30,232 users