QUESTION 41

The reason why a database table is in the second normal form (2NF), but not in the third form (3NF) is because:

a. There is a non-prime attribute that is transitively dependent on the key of the table.

b. There is a one-to-many relationship embedded in the table.

c. both a. and b.

d. neither a. nor b.

QUESTION 44

If there is a many-to-many relationship between entity A and B, then

a. there exists a functional dependency from the primary key in A to the primary key in B, i.e., PK(A) ? PK(B).

b. there exists a functional dependency from the primary key in B to the primary key in A, i.e., PK(B) ? PK(A).

c. both a. and b.

d. neither a. nor b.

QUESTION 45

A key in a relational database table

a. is a minimal set of attributes.

b. uniquely identifies a tuple (record) in a relation table.

c. both a. and b.

d. neither a. nor b.