• edited by
694 views
1 1 vote
why is prime->prime dependency doesn't violates 2nf . say table(a,b,c,d,e) and {(a,b),(d,e)} are candidates key and there is a relation from a->d. does it follow functional 2nf rule why?

1 Answer

0 0 votes

See violation of 2NF happens when Some CK partially (particular partial dependency) dertimines a NON PRIME ATTRIBUTES.

2NF only concerns non-prime attributes. It aims to remove partial dependencies of non-prime attributes on candidate keys. Simple, if there is no non prime attributes , then it's in 2NF.

A-->D 

Position:
Show:

Related questions

0 0 votes
1 1 answer
565
565 views
3 3 votes
2 2 answers
5.0k
5.0k views
Parshu gate asked Nov 19, 2017
4,974 views
How is it option D??
0 0 votes
1 answers 1 answer
2.5k
2.5k views
Chetnawadhwa asked Nov 2, 2016
2,515 views
Tell whether the following decomposition of relations lossless and dependency preserving or not.1. R(ABCDEFGHIJ) and FD setsAB->C, A->DE, B->F, F->GH, D->IJa) D1"={ DI...
3 3 votes
1 1 answer
131
131 views
GO Classes asked Sep 17
131 views
Consider $R(A,B,C,D,E,F,G,H,I,J)$ with $F=\{AB\to CD,\ D\to EFG,\ FG\to H,\ A\to I,\ AB\to EG,\ AI\to IJ\}$. The candidate key is $AB$.Which of the following is a valid $...