QUESTION 32 Please indicate what the highest normal form is for the given relati

Question

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)

Explanation / Answer

Question 32: This has partial as well as transitive dependency. So, this relation is in 1NF.

(AB -> C, AB -> D) This is partial dependency.

(AB -> D, D -> B) . This is Transitive Dependency.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects