A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.
A. 2NF
B. 3NF
C. BCNF
D. 1NF
Answer:A
A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.
A. 2NF B. 3NF C. BCNF D. 1NF
Explanation:A relation is in 3 NF if an attribute of a composite key is dependent on an attribute of other composite key. (If an attribute of a composite key is dependent on an attribute of other composite key then the relation is not in BCNF, hence it has to be decomposed.). 2. What are the desirable properties of a decomposition