Register

3NF-property

523 views
2 votes
2 votes

A relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of R

Here, what is the actual meaning of word key ? Does it mean prime attribute or super key or non-prime attribute ?

plzz explain...

User Avatar

2 Answers

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
0 votes
0 votes
1 answer
3
PRIYANKA pp PIU asked Mar 16
116 views
Explain why BCNF is said to be improved 3NF.
User Avatar
0 votes
0 votes
2 answers
4
Souvik33 asked Jan 14, 2023
541 views
Made Easy Test Series | 3NF | True/False
A relation is in 3NF if every non-prime attribute of R is fully functionally reliant on every key of R TRUE FALSE
A relation is in 3NF if every non-prime attribute of R is fully functionally reliant on every key of RTRUEFALSE
User Avatar
Link Copied!