Normalization
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 316 |
Consider a Relational 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
Then the decomposition of R into R1 (A, B) and R2(C, D) is
| dependency preserving and lossless join
| |
| lossless join but not dependency preserving | |
| dependency preserving but not lossless join | |
| neither dependency·preserving nor lossless join |
Question 316 Explanation:
R1(A,B) contains FD A→B
R2(C,D) contains FD C→D
So, yes dependency preserving.
But there is no common attribute between R1 and R2, hence not lossless join.
R2(C,D) contains FD C→D
So, yes dependency preserving.
But there is no common attribute between R1 and R2, hence not lossless join.
Correct Answer: C
Question 316 Explanation:
R1(A,B) contains FD A→B
R2(C,D) contains FD C→D
So, yes dependency preserving.
But there is no common attribute between R1 and R2, hence not lossless join.
R2(C,D) contains FD C→D
So, yes dependency preserving.
But there is no common attribute between R1 and R2, hence not lossless join.