Explanation: Lossless join and dependency preserving are the two goals of the decomposition. 3. R (A,B,C,is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition.
A. A->B, B->CD
B. A->B, B->C, C->D
C. AB->C, C->AD
D. A->BCD
Answer:A
Explanation: Lossless join and dependency preserving are the two goals of the decomposition. 3. R (A,B,C,is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition.
A. A->B, B->CD B. A->B, B->C, C->D C. AB->C, C->AD D. A->BCD
Explanation: This relation gives a relation without any loss in the values. Class (course id, title, dept name, credits, sec id, semester, year, building, room number, capacity, time slot id)