Answer below questions: --> A relation is in second normal form if it is in 1NF

ID: 3739670 • Letter: A

Question

Answer below questions:

--> A relation is in second normal form if it is in 1NF and :

every attribute is single-valued

every attribute is determined by a portion of the key

every nonkey attribute is dependent on the entire key

no nonkey attribute determines another

--> In the relation R(A;B;C;D) with the composite key fA;Bg, which of the following functional

dependencies would demonstrate that the relation is not 2NF?

A --> B

A --> C

C --> D

any of the above

--> A relation having only one candidate key is in third normal form if it is in 2NF and:

no nonkey attribute is determined by only part of the key

no nonkey attribute is dependent on another nonkey attribute

no part of the key is dependent on another part of the key

there are no partial functional dependencies

Here is my answer:

-->A relation is in second normal form if it is in 1NF and:

Answer is : every nonkey attribute is dependent on the entire key .

--> In the relation R(A;B;C;D) with the composite key fA;Bg, which of the following functional

dependencies would demonstrate that the relation is not 2NF?

Answer is : A --> C functional dependencies demonstrate that the relation is not 2NF..

--> A relation having only one candidate key is in third normal form if it is in 2NF and:

Answer is : no nonkey attribute is dependent on another nonkey attribute.

Thank You!!

Have a nice day.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.