Register

3NF Normalization Doubt

370 views
3 votes
3 votes

Is a relation with multiple candidate keys in 3NF?

According to this,

As per the first definition any relation having multiple candidate keys will have transitive dependency to a non key attribute.

My Inference : Since it has a Transitive dependency thus any relation having multiple candidate keys will not be in 3NF.

Image Source(Website)  and the website was mentioned here : Gate CSE Database Page (Normal Forms Quick View)

I just want to confirm that the definition and my inference given is correct or not.And if it is correct can you please provide some other reference illustrating the same concept.

User Avatar

1 Answer

Best answer
0 votes
0 votes

The definition is fully correct, but your inference is not. Please do read the definition once again.... it already answers your doubt (Sentence starting with - Note that .... ).

• selected by
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
2 answers
1
Harsh Kumar asked Jul 4, 2018
1,076 views
Normalization - 3NF doubt
A relation has the attributes R(ABCDEPG). The set of Functional Dependencies are : $F: { AB \to CD, DE \to P, C\to E, P\to C, B \to G }$ ... A LOSSLESS AND DEPENDENCY PRESERVING PROPERTY IN 3NF - But I am not getting the Dependency Preservation property. Is something wrong with the decomposition ?
A relation has the attributes R(ABCDEPG). The set of Functional Dependencies are :$F: { AB \to CD, DE \to P, C\to E, P\to C, B \to G }$After normalising this relation til...
User Avatar
4 votes
4 votes
1 answer
2
anabee asked Jan 15, 2018
1,740 views
3NF Fully functional dependent
Consider the following statements: A relation R is in 3NF, if every non-prime attribute of R, is fully functionally dependent on some key of R. State True or False
Consider the following statements:A relation R is in 3NF, if every non-prime attribute of R, is fully functionally dependent on some key of R.State True or False
User Avatar
1 votes
1 votes
0 answers
3
JAINchiNMay asked Dec 1, 2022
442 views
self doubt
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attribute True or false
Any attribute(s) determining a prime attribute, automatically becomes a prime(s) attributeTrue or false
User Avatar
Link Copied!