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

A table with a single field primary key can never

A table with a single field primary key can never

a. Violate first normal form
b. Violate second normal form
c. Violate third normal form
d. Have more than one non-key attribute
e. Have more than 4 fields

Answer: B

For a table to be in first normal form, it must

For a table to be in first normal form, it must

a. Have a composite primary key
b. Have at least one foreign key
c. Not have a composite primary key
d. Not have any foreign keys
e. Not have any repeating groups

Answer: E