Open In App
Related Articles

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

Improve Article
Save Article
Like Article

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

Whether you're preparing for your first job interview or aiming to upskill in this ever-evolving tech landscape, GeeksforGeeks Courses are your key to success. We provide top-quality content at affordable prices, all geared towards accelerating your growth in a time-bound manner. Join the millions we've already empowered, and we're here to do the same for you. Don't miss out - check it out now!

Last Updated : 22 Mar, 2018
Like Article
Save Article
Similar Reads