1

Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is

Correct Answer: not dependency preserving and not lossless join

Make the most of this question

This page focuses on one Database Management System (DBMS) question from Engineering. After checking the answer, return to the topic list to practice more or run a timed set.

Database Management System (DBMS) MCQ: Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is | Extra Education