Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decompositio…

A. dependency preserving and lossless join. Explanation: While decomposing a relational table we must verify the following properties:

Question #1539 of 749+ in Database Management System

📝 Question #1539

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

⌨️ Press A B C D to select

✓

A dependency preserving and lossless join Correct

B lossless join but not dependency preserving

C dependency preserving but not lossless join

D not dependency preserving and not lossless join

📚 Want More?

749+ questions with detailed answers