Open In App

UGC-NET | UGC NET CS 2016 Aug – III | Question 10

Like Article
Like
Save Article
Save
Share
Report issue
Report

Consider the table R with attributes A, B and C. The functional dependencies that hold on R are : A → B, C → AB. Which of the following statements is/are True ?
I. The decomposition of R into R1(C, A) and R2(A, B) is lossless.
II. The decomposition of R into R1(A, B) and R2(B, C) is lossy.
(A) Only I
(B) Only II
(C) Both I and II
(D) Neither I nor II


Answer: (C)

Explanation:
Decomposition of R into R1(C, A) and R2(A, B) is lossless.
Because C → A, A → B. So, C → AB can be derived and there is no loss.
Decomposition of R into R1(A, B) and R2(B, C) is lossy.
Because A → B, C → B are derived but we can’t derive C → AB, So it is lossy.
So, option (C) is correct.


Quiz of this Question


Last Updated : 13 Apr, 2018
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads