QUESTION 32

Please indicate what the highest normal form is for the given relation schema R(A, B, C, D), the key for the schema: AB, and the set of functional dependencies, AB -> C, AB -> D, D -> B.

a. The first normal form (1NF)

b. The second normal form (2NF)

c. The third normal form (3NF)

d. The Boyce-Codd normal form (BCNF)

QUESTION 36

Please indicate what the highest normal form is for the given relation schema R(A, B, C, D), the key for the schema: AB, and the set of functional dependencies, AB -> C, AB -> D.

a. The first normal form (1NF)

b. The second normal form (2NF)

c. The third normal form (3NF)

d. The Boyce-Codd normal form (BCNF)

QUESTION 43

Please indicate what the highest normal form is for the given relation schema R(A, B, C, D), the key for the schema: AB, and the set of functional dependencies, AB -> C, C -> D,

a. The first normal form (1NF)

b. The second normal form (2NF)

c. The third normal form (3NF)

d. The Boyce-Codd normal form (BCNF)