GATE CSE
First time here? Checkout the FAQ!
x
0 votes
69 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 Active (2.3k points) 3 8 19 | 69 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 Boss (5.7k points) 7 11 33 | 56 views
0 votes
0 answers
2
asked in Linear Algebra by sid1221 Active (2.1k points) 1 15 41 | 59 views
0 votes
2 answers
3


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
Top Users Oct 2017
  1. Arjun

    23678 Points

  2. Bikram

    17268 Points

  3. Habibkhan

    8950 Points

  4. srestha

    6446 Points

  5. Debashish Deka

    5478 Points

  6. jothee

    5128 Points

  7. Sachin Mittal 1

    4882 Points

  8. joshi_nitish

    4486 Points

  9. sushmita

    4032 Points

  10. Rishi yadav

    3974 Points


Recent Badges

Popular Question Hira Thakur
Notable Question amaity
Notable Question srestha
Nice Answer Madhab
Renewal Madhab
Popular Question sourabh
Notable Question K ANKITH KUMAR
Great Answer saloni
Resurrection saloni
Great Question Ishrat Jahan
27,406 questions
35,255 answers
84,502 comments
33,454 users