Assume a relation R with the schema R(A, B, C, D, E) and a set F of functional dependencies as follows; F = {A → B, C → D, D → E} The relation R is not in Second Normal Form (2NF). Why?
A. R has no repeating groups
B. R has transitive functional dependencies
C. R has partial functional dependencies
D. R has no key
Answer:C
Assume a relation R with the schema R(A, B, C, D, E) and a set F of functional dependencies as follows; F = {A → B, C → D, D → E} The relation R is not in Second Normal Form (2NF). Why?
A. R has no repeating groups B. R has transitive functional dependencies C. R has partial functional dependencies D. R has no key