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