A table in third normal form

A table in third normal form 

a. Cannot have any repeating groups
b. Has no transitive dependencies
c. Has no non-key fields depending on only a part of the composite primary key
d. All of the above
e. a and b

Answer: D

A third normal form violation can occur for which of the following tables?

A third normal form violation can occur for which of the following tables?

a. A table with a single field primary key and two non-key attributes
b. A table with a composite primary key and two non-key attributes
c. A table with a composite primary key and one non-key attribute
d. All of the above
e. a and b

Answer: E

A "transitive dependency" is a dependency between

A "transitive dependency" is a dependency between

a. Two primary keys
b. A primary key and a candidate key
c. A primary key and a non-key attribute
d. Two non-key attributes
e. A non-key attribute and a composite primary key

Answer: D

Only a table with ______ can potentially violate second normal form

Only a table with ______ can potentially violate second normal form

a. Two or more non-key attributes
b. A foreign key
c. A repeating group
d. A composite primary key
e. Two candidate keys

Answer: D