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
A. Partition constraint
B. Dependency preservation
C. Redundancy
D. Security
Answer:A
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
A. Partition constraint B. Dependency preservation C. Redundancy D. Security
Explanation: Lossless join and dependency preserving are the two goals of the decomposition. 3. R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition.