Open In App

UGC-NET | UGC NET CS 2017 Jan – II | Question 19

Like Article
Like
Save
Share
Report

Consider a schema R(MNPQ) and functional dependencies M → N, P → Q. Then the decomposition of R into R1 (MN) and R2(PQ) is________.
(A) Dependency preserving but not lossless join
(B) Dependency preserving and lossless join
(C) Lossless join but not dependency preserving
(D) Neither dependency preserving nor lossless join.


Answer: (A)

Explanation: Schema R(MNPQ) is decomposed into R1(MN) M → N is preserved and R2(PQ) P → Q is also preserved, dependency will be preserved and there will be no loss of any dependency.
So, option (A) is correct.


Quiz of this Question


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