recategorized by
3,623 views
3 votes
3 votes

The third normal form is based on the concept of_____

  1. Closure Dependency
  2. Transitive Dependency
  3. Normal Dependency
  4. Functional Dependency
recategorized by

2 Answers

Best answer
2 votes
2 votes

The third normal form (3NF) is a normal form used in database normalization Codd's definition states that a table is in 3NF if and only if both of the following conditions hold:

  • The relation R (table) is in seconfd normal form(2NF)
  • Every non-prime attribute of R is non-transitively dependent on every key of R.

A non-prime attribute of R is an attribute that does not belong to any candidate key of R.

A transitive dependency is a functional dependency in which 

X → Z(X determines Z) indirectly, by virtue of X → Y and Y → Z (where it is not the case that Y → X).

 

Hence,Option(B)Transitive Dependency.

selected by
0 votes
0 votes

Answer : Transitive Dependency

Third Normal form applies that every non-prime attribute of table must be dependent on primary key, or we can say that, there should not be the case that a non-prime attribute is determined by another non-prime attribute. So this transitive functional dependency should be removed from the table and also the table must be in Second Normal form.

Reference : 3 NF

Answer:

Related questions

0 votes
0 votes
2 answers
1
go_editor asked Jul 13, 2016
2,038 views
Referential integrity is directly related toRelation keyForeign keyPrimary keyCandidate key
2 votes
2 votes
1 answer
3